Answer all questions, we have to provide SQL queries for the following:

1. Select the departments that sell Compasses and are not the navigation department
2. Find the average delivery quantity and round it to the nearest whole number
3. Select the empfname of all employees and print thm out by department and within department by empfname
4. Select everything from the QDEL table
5. Select delivery number, item name, and department name from the qdel table
6. Select all items with tent in the name
7. Select all departments on the 1, 2, and 4^th floor
8. How many people are in each department? List the department name and the number.
9. List out all departments with at least 2 employees.

QSALE "saleno saleqty QDEPT *deptname deptfloor dethroner Department boss QEMP *empno empfname empsakary employee boss QITEM *itemname itemtype itemcolor QDEL *delno delaty QSPL *splno spiname Relational Tables QSALE saleno QITEM itemname QDEL delno QSPL spino QDEPT deptname QEMP empno saleqty itemtype delaty splname deptfloor empfname itemname itemcolor itemname deptphone empsalary deptname deptname empno deptname spino bossmo