Write the following SQL queries based on the database schema

SALES (DEPT. ITEM, VOLUME) DEPT DNAME, FLOOR) ITEM (INAME, TYPE, COLOR) EMPLOYEE (ENO, ENAME, MGR. DEPT. SALARY, JOB-STATUS) SUPPLIER (SNO, SNAME) SUPPLY (SUPPLIER, DEPT, ITEM. VOLUME) 1 Write the following SQL queries, based on the database schema Find the items sold by no department on the second floor Find the items sold by all department on the second floor Find the items sold by at least two departments on the second floor Find the departments where all the employees earn less than their manager Find the name and salary of the managers who earn more than ten employees List the items supplied by all suppliers that supply all items of type A List the supplier-department pairs whose department sells all items it is supplied by the supplier. List the items supplied to all departments by all suppliers