Using theClassic Models relation scheme (for the relation scheme model), write the relational algebra statement using one or another set operator for the following queries:

1. List the customerName of all customers who live in a state that does not have one of our offices. Take into account that a state name is only unique within a given country. For instance, both Russia and the US have a state called Georgia.

2. List productCode, productName, and productVendor for each product that has never been ordered in June. Remember that we have the month function that returns the number of the month component of a data, and January is month number 1.

3. List the Customers that did not Order any products in 2015.

4. List all CustomerNames who have never had an order go to the Shipped status.

5. Using a set operator, list the last names of those employees if there is at least one customer who also has a contact with that same last name.

6. List all people that we deal with (employees and customer contacts). Display first name, last name, customer name (or just the literal Employee for employees).

7. List the names of all Customers who didnt Order any products in 2015