Using the sql code from the link, solve the following problems. The number in the parentheses represents the number of rows to be produced.

http://web.csulb.edu/%7Emopkins/cecs323/mysqlsampledatabaseinderby.sql

1.Using the where clause, List all employees that don't have a manager (1)

2. Using the natural join clause, select the List of productlines and vendors that supply the products in that productline. (65)

3. Using the inner join clause,select customers that live in the same state as their employee representative works (26)

4. Using the multiple join clause, select customerName, orderDate, quantityOrdered, productLine, productName for all orders made and shipped in 2015 (444)

5. Using the outer join clause, List products that didn't sell (1)

6. Using the outer join clause, List all customers and their sales rep even if they dont have a sales rep (122)