Database PetersPan

Idea : To make avanced request information from a database.

Background : The exercise of PetersPan see Exercise#1

Step 1: select from Several tables

1. List all information of thw waiters serving tables at the window
    
2. List all information of the order (OrderLine) for Customer "King Arthur"
    
3. List all information of the orderLines ordered by the customer names
    
4. List the names of the MenuItem  and the customer name which "King Arthur" has ordered
    
5. List Price of the order for each Customers
    
6. List Price of the order for each Customers where the the name is something with 'King'
    
7. List Price of the order of the 16/feb 2018
    
8. List Price of the order for Breakfast (8AM-10:30AM)


9. List Price of the order and the name of the cutomer for Breakfast (8AM-10:30AM)
    

Step 2: Find a request for your class mates

Find a SQL request to pose for your stundent class mates.
Before you can pose it check that you have a solution.