Show the data in all your tables in your project document (a clear and readable screen shot)
Fantastic news! We've Found the answer you've been seeking!
Question:
Show the data in all your tables in your project document (a clear and readable screen shot)
- Customer
- Order
- Order_line
- Product
- ProductLine
The SQL command, The output, The number of rows affected.
- List the customers who live in Plano or Seattle. Order them by zip code, from high to low.
- What is the average standard price for all products in inventory?
- Which orders have been placed since 10/05/2015?
- List product name, finish, and standard price for all desks and all tables that cost more than $300 in the Product table.
- Find only states with more than one customer.
- For each customer who has placed an order, what is the customer's ID, name and order number?
- What are the customer IDs and names of all customers, along with order IDs for all the orders they have placed?
- Assemble all information necessary to make an invoice for order number 546.
- What are the employee ID and name of each employee and the name of his or her supervisor (label the supervisor's name Manager)?
- Display the customer names of all customers who have ordered (on the same or different orders) both products with IDs 3 and 4.
- For each customer, list the CustomerID and total number of orders placed.
- For each customer, list the CustomerID and the total number of orders placed in 2015.
- List the customers who purchased the largest quantity of any NewFurniture product in a given line item and the customer(s) who purchased the smallest quantity and returns the result in one table.
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date: