Lab 6

1. Write a SQL statement that finds out each order number followed by the name of the customers who made the order.
2. Write a query to display all the orders from the orders table issued by the salesman "WHATEVER NAME"
3. Write a query to display all the orders for the salesman who belongs to the city WHATEVER
4. Write a query to display all the orders which values are greater than the average order value for WHATEVER DATE ('01-JUN-19')
5. Create a view to display the salesmans in your table (CREATE VIEW salesman AS ...)
6. Write a query to extract the data from the orders table for those salesman who earned the maximum commission.