step$1$

Write the SQL to create the structure and copy the data from the following table to the suggested destination:

Source:

Database: AdventureWorks $2019$

Schema: Raj

Table: FIPS$\_$list

Destination:

Database: DM$\_\{$myGateID

Schema: default $($dbo$)$

Table: FIPS$\_$list

Columns: All

Once this is copied, write the SQL to retrieve all the data from the NEWLY created $($destination$)$ table. You will now have two SQL statements in the query window.

step $2$

Use SQL to add a column to the newly created FIPS$\_$list table $($TASK $1)$ with the following characteristics:

Name: State$\_$code

Type: nchar$(2)$

Nulls: allowed

step $3$

You must replace the nulls in the "State$\_$code" column of the FIPS$\_$list table in your database with data available at the following DB source. That is$,$ the state code for Alabama is $\text{'}$AL$\text{'},$ Kentucky is $\text{'}$KY$\text{'}$ etc. All of these codes are available in the 'abbr' column of the following database$/$table

Source:

Database: AdventureWorks $2019$

Schema: Raj

Table: StateInfo

The text shows how this is done with SUBQUERY first and JOIN later. You can use either approach