Add column and Populate to EXISTING table

ALTER TABLE Table_name
ADD COLUMN_NAME varchar(20)


UPDATE [table]
SET [column] = 'Confirmed'