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

 

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 Expert Approved Answer
Step: 1 Unlock

1 sql SELECT StandardCost FROM Products WHERE ProductName Northwind Traders Dried Apples 2 sql SELEC... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!