Write a query that display order id or order no., customer_id , and customer address 2. Write
Question:
Write a query that display order id or order no., customer_id , and customer address
2. Write a query that display the product id or product number that have been NOT sold to any customer.
3. Write a query that display product information (productid, desc, cost, and another information of your choice) and it is related inventory or store if there is any.
4. Write a query that display the list of customers/clients who made order and the list of the products in each order.
5. Write a query that display the list of customers/ clients who never made order.
6. Write a query that display the list of products that never sold.
7. Write a query that display the top customers (who made high purchase in total)
8. Write a query that display the worst customers (who made low purchase in total or no purchase at all )
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill