Write the following in one SQL file.

1. Complete SQL Exercises 3.3 on Page 101.
2. Complete SQL Exercises 3.4 on Page 101.
3. Complete SQL Exercises 3.6 on Page 101-102.
4. Complete SQL Exercises 3.10 on Page 102-103.

Display all UK customers . Show customer name and email . Sort customer name in alphabetic order . 4 7 7 12 18 5 Exercise 3.3 Email CustomerName E Fun Bectronics4U 1 green@ef.com smith@e4u.com 2 Exercise 3.4 Display all products delivered in the first 9 days of October, 2016. Show product ID, quantity, and date. 1 Productid 1 2 3 2 Quantity Delivery Date 2 2016-10-01 09:30:00.0000000 10 2016-10-02 11:10:00.0000000 10 2016-10-05 09:15:00.0000000 20 2016-10-07 14:00:00.0000000 15 2016-10-07 15:30:00.0000000 3 4 4 5 5 Exercise 3.5 Display all products with supplier price between $100.00 and $200.00. Show the product ID, quantity, and price. Productid 3 1 Quantity 10 15 25 Price 129.99 139.99 169.99 5 6 3 Exercise 3.6 Display all employees who do not provide a phone number. Show the employee's first name and last name. 101 First Name 1 Christina Nicholas LastName Robinson Pinksion 2 Display all customers that placed orders before January 1, 2017 or After May 1, 2017. Show customer ide Productid 1 1 2 1 3 2 4 4 5 7 6 7 Exercise 3.9 Price 1099.99 1199.99 1199.99 79.99 79.99 69.99 order date. Customerld 1 1 2 3 Order Date 2017-05-03 2017-05-08 2016-11-08 2016-12-23 3 5 7 4. Exercise 3.10 Display all products that are delivered more than 5 units at a time and the supplier price is either under $100.00 or over $1000.00. Show the product ID, supplier price, and delivery date. 102 Productld 2 1 2. 4 Price Delivery Date 1199.99 2016-10-02 11:10:00.0000000 79.99 2016-10-07 14:00:00.0000000 79.99 2016-10-11 11:10:00.0000000 69.99 2016-10-12 09:50:00.0000000 3 3 7 7