Source DB$-$ Adventure Works $2019$

Schema: Purchasing

Table: Vendor

Destination DB$-$ your DB for this exam

Schema: default

Table: mygateID$\_$Vendor $($Your mygateID$)$

Write and run the $(2)$ SQL statements to

copy data from the source to the destination table $($see above$)$ for vendors who are active and have a credit rating of $1$ or $2$

Add a new vendor $($to the newly copied table$)$ the following info:

Business entity ID: $1700$

AccountNumber: Your MygateID followed by $0002$

Name: Your Name with $\text{'}$LLC$\text{'}$ at the end

Credit rating: $2$

Preferred vendor status: $0$

ActiveFlag: $1$

Purchasing web service URL: NULL

Modified date: today's date