formulate queries

[c-cha16]

• [ ] Get detail of all books in the Bookstore.
• [ ] Get detail of all books that are back order.
• [ ] Get detail of all the special orders for a given customer.
• [ ] Get detail of all purchases made by a given customer.
• [ ] Get detail of all the sales made by a given employee on a specific date.
• [ ] Get details of all purchases made. For each customer, return the total
  • • [ ] amount paid for the books ordered since the beginning of the year.
• [ ] List every book ordered but not received within the period set has passed.