Question: Using the Northwind database, please write the SQL to answer the following questions. Write the SQL for each question to turn in . 1 .
Using the Northwind database, please write the SQL to answer the following questions. Write the SQL for each question to turn in
List all the rows and columns from the customers table.
List all employees who live in the region of Washington.
List all employees names and birth date in age order oldest person first
List managers and the employees they manage names only
List the customer name and order date of all customers who have made orders.
List the customer name and order date of all customers who have or have not made an order.
List the customer name and the total amount of all items they have ordered quantity unit price
List the customer and the total quantity ordered of all items ordered.
List all customers names and mailing address where the shipping address is the same as their mailing address.
List customers who dont have any orders
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
