Question: Write SQL statements to: 1. Get the standard cost of Northwind Traders Dried Apples 2. List the states where our shippers reside (each state

Write SQL statements to: 1. Get the standard cost of Northwind Traders Dried Apples 2. List the states where our shippers reside (each state should only be listed once) 3. Determine the average price of beverages 4. For each purchase order, display the purchase order id and how many months it has been since it was submitted 5. Add a new customer "Porsche International", with contact "Mercedes Lewis" and address "1246 Oxford Court, Jackson, MS 39213" 6. For each customer, display the company name and how many orders have been placed by that customer (include 0 values in this query) 7. For each product in the database, list the product name and the name of each supplier for that product. 8. List the company names for all customers who have ordered Northwind Traders Crab Meat. Note: For each statement, just submit the SQL statement ("SELECT ..." as appropriate). You do not need to include the results of each statement.
Step by Step Solution
There are 3 Steps involved in it
1 sql SELECT StandardCost FROM Products WHERE ProductName Northwind Traders Dried Apples 2 sql SELEC... View full answer
Get step-by-step solutions from verified subject matter experts
