The following problems are based on the northwind database you have been using for the projects. Each problem should be solved by a single SQL statement. Submit a PDF file with your answers.

Create a table named Spanish$-$Orders that contain the OrderID, OrderDate, CustomerID, CompanyName $($of customer$)$ of all orders made by a customer from Spain;

Write an INSERT statement that adds a row to the Shippers table with the following values: ShipperID: $4,$ CompanyName: DHL$,$ Phone: $(813)503-8888.$

Write an INSERT statement to add all suppliers to the Customers table. For each supplier, copy the value of SupplierID to CustomerID, and those of the other columns to the ones with the same name in the Customers table.

Write a DELETE statement that deletes all rows of the Orders table that satisfy the following condition: the ShipCountry is USA and the freight is lower than $$50\mathrm{.}00.$

Write a DELETE statement that deletes all rows of the Orders table that satisfy the following condition: the order is made by a customer from Germany. $($Hint: need to do a JOIN$).$

Write an UPDATE statement that modifies the Suppliers table. Change the Region to $$Unknown$$ for all the suppliers from USA.

Write an UPDATE statement that modifies the Orders table by doubling the freight for all orders made by a customer with the ID $$TOMSP$.$