6. Use subquery and show details of the customers that have not placed any orders. If a...
Fantastic news! We've Found the answer you've been seeking!
Question:
6. Usesubqueryand show details of the customers that have not placed any orders. If a customer (i.e, its CustomerID) is not in the table of orders, that means the customer has not placed any orders. (Returning error code unknown column orders.customer_id in where clause.
7. UseDeletestatement to remove products that have not been ordered by any customers.Hint:A product that is not in the table of order_details means the product has not been ordered, find (without duplicate of those products. ( saying that cannot delete or update parent row)
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date: