SQL Review DML

Sheet $3($Northwind$)$

Please write the SQL to accomplish the following:

$1.$ Add yourself as a customer to the customer table.

$2.$ Make an order for yourself of $5$ Filo Mix and $2$ Spegesild.

$3.$ Write the SQL to change your order to $7$ Filo Mix.

$4.$ Change your address and City in the customer table $($one statement$).$

$5.$ Northwind wants to start selling widgets from the World federation Widget Corporation. Please insert all rows needed for Northwind to start selling Widgets. Northwind will be selling Widgets for $$8\mathrm{.}99$ each. What other table$$s might have to be updated?

$6.$ Make another order for yourself of $10$ widgets.

$7.$ Write the SQL to delete all rows you added in numbers $1-6.$