The data base for the customer is here https://goo.gl/ftzOxl

Exercise 6.6 Display customers, their orders, and the most cxpensive unit price in the order. Show customer ID customer name, order ID, order date, and unit price for the most expensive item in the order. Customerld CustomerName Orderld OrderDale 2017-01-03 1499.99 2017-03-05 1599.99 2017-05-03 199.99 2017-02-23 1449.99 2017-05-08 1499.99 2017-04-13 99.99 2016-11-08 999 99 2016-12-23 79.99 Highest unit price in order 2 Just Eectronics Just Electronics5 Beyond Electronics 3 Beyond Electronics 6 E Fun Overstock E Electronics4U 2 2 3 6 4 5 8 Exercise 6.9 Display all customers. If a customer has placed any orders, also display the highest unit price in a that customer. Otherwise, display null. We want to know each customer's highest price item ever ord Show customer ID, customer name, and the highest unit price in any order of that customer. Customerld CustomerName Highest unit price 1599.99 Just Electronics Beyond Blectronics 1449.99 Beyond Blectronics 1499.99 E Fun Overstock E E Fun Electronics4U 79 99 99.99 999.99 NULL Cheap Electronics NULL Exercise 6.10 Display all employees with the same last name. Show their full name and date of birth. Employee name 1 Dianne Hart 2 Black Hart 3 Maria Law 4 Alice Law Excrcisc 6.12 BirthDate 1978-12-03 1982-11-09 1988-07-13 1988-12-13 Display all states the LifeStyle has a business (customer or supplier). Show state and coury State Countr USA 3 England UHK GiA IL NY USA USA USA Canada South Korea 5 Ontario Exercise 6.6 Display customers, their orders, and the most cxpensive unit price in the order. Show customer ID customer name, order ID, order date, and unit price for the most expensive item in the order. Customerld CustomerName Orderld OrderDale 2017-01-03 1499.99 2017-03-05 1599.99 2017-05-03 199.99 2017-02-23 1449.99 2017-05-08 1499.99 2017-04-13 99.99 2016-11-08 999 99 2016-12-23 79.99 Highest unit price in order 2 Just Eectronics Just Electronics5 Beyond Electronics 3 Beyond Electronics 6 E Fun Overstock E Electronics4U 2 2 3 6 4 5 8 Exercise 6.9 Display all customers. If a customer has placed any orders, also display the highest unit price in a that customer. Otherwise, display null. We want to know each customer's highest price item ever ord Show customer ID, customer name, and the highest unit price in any order of that customer. Customerld CustomerName Highest unit price 1599.99 Just Electronics Beyond Blectronics 1449.99 Beyond Blectronics 1499.99 E Fun Overstock E E Fun Electronics4U 79 99 99.99 999.99 NULL Cheap Electronics NULL Exercise 6.10 Display all employees with the same last name. Show their full name and date of birth. Employee name 1 Dianne Hart 2 Black Hart 3 Maria Law 4 Alice Law Excrcisc 6.12 BirthDate 1978-12-03 1982-11-09 1988-07-13 1988-12-13 Display all states the LifeStyle has a business (customer or supplier). Show state and coury State Countr USA 3 England UHK GiA IL NY USA USA USA Canada South Korea 5 Ontario