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.
1. List all the rows and columns from the customers table.
2. List all employees who live in the region of Washington.
3. List all employees names and birth date in age order (oldest person first).
4. List managers and the employees they manage (names only).
5. List the customer name and order date of all customers who have made orders.
6. List the customer name and order date of all customers who have or have not made an order.
7. List the customer name and the total amount of all items they have ordered (quantity * unit price).
8. List the customer and the total quantity ordered of all items ordered.
9. List all customers names and mailing address where the shipping address is the same as their mailing address.
10. 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 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!