Using Access(or your class SQL Server account) create the SQL queries to answer the following questions from your textbook exercises at the end of the Reference 2 chapter which is immediately before Chapter 11.#51 is not in your text. Name your queries with the problem number. Attach your Q database in Blackboard.
1) Find the items delivered by all suppliers.
2) Find the green items delivered by all suppliers. Also answer the question for khaki items.
3) List each employee and the difference between his or her salary and the average salary of his or her department. You may want to look at #52 (the example queries in Reference 2 chapter). If you are using Access this won't work.
4) List the names of managers who supervise only one person.
5) List the department and the item where the department is the only seller of that item.
6) Which department has the highest average salary?
7) Find the items (delno, delqty, itemname, and deptname) which have the same quantity delivered as the total quantity sold (of the same items).
Attachment:- Database.rar