Equivalent SQL Command of index match (excel) to update column in existing table name

I need to update an existing table by adding a new column. Below is the sample data for the first table which needs to be updated with the new column(Ticket_No_Calc).

Welcome to the forum.

alter table [existing table] add Ticket_No_Calc int null