Write SQL statements to answer the following questions based on the Pine Valley Furniture Company database. Note: Depending on what DBMS you are using, some field names may have changed to avoid using reserved words for the DBMS.
- Find customers who have not placed any orders.
- Display order number, customer number, order date and items ordered for some customer (example shows CustomerID=4, you may choose another valid customer ID number in your solutions):
- Display each item ordered for order #1, its standard price, and total price for each item ordered:
- Total the cost of the order for order #1:
- List each customer who has bought computer desks and the number of units bought by each customer: