Find the names of employees in the Marketing department.

Find the items sold by a department on the second floor.

Find the names of items sold on floors other than the second floor.

For items that have been sold, find the items sold by no department on the second floor.

Find the items sold by all departments on the second floor.

Find the items sold by at least two departments on the second floor.

Find the name and salary of Clare's manager.

Find numbers and names of employees who make more than their manager.

Find the departments where all the employees earn less than their manager.

Report the number of direct employees of each manager. Report the boss's name.

Find the names of employees who are in the same department as their manager. Report the employee, department, and manager name.

List the departments where the average salary of the employees of each manager is more than $25,000. Exclude the manager's salary.

List the name and salary of the managers with more than two employees.

List the name, salary, and manager of the employees of the Marketing department who have a salary over $25,000.

List the names of the employees who earn more than any employee in the Marketing department.

Among all the departments with total salary greater than $25,000, find the departments that sell Sextants.

List the items delivered by every supplier that delivers all items of type N.

Find the names of suppliers that deliver compasses.

Find the suppliers that do not deliver compasses.

Find the names of suppliers that deliver both compasses and an item other than compasses.

List the departments that have not recorded a sale for all the items of type N.

For departments that sold items, list those departments that have at least one sale of all the items delivered to them.

List the supplier-department pairs where the department sells all items delivered to it by the supplier.

For departments that have sold items, list those items delivered to all departments by all suppliers.

List the items sold only by departments that sell all the items delivered to them.

Who are the suppliers that deliver all the items of type N?

List the names of suppliers that deliver only the items sold by the Books department.

List the names of suppliers that deliver all and only the items sold by the Equipment department.

List the names of suppliers that deliver every item of type C to the same department on the second floor.

List the names of suppliers that deliver at least two items of type N to departments.

List the names of suppliers that deliver all the items of type B to departments on the second floor who sell all the items of type R.

List the names of suppliers that deliver all the items of type B to the departments that also sell all the items of type N.

List the items delivered by exactly one supplier.

List the distinct names of suppliers and items where the supplier is the only deliverer of that item.

List the suppliers that deliver at least 10 items.

For each item, give its type, the departments that sell it, and the floor locations of those departments.

List the departments for which each item delivered to the department is also delivered to some other department.

List each item delivered to at least two departments by each supplier that delivers it.

List the items that are delivered only by the suppliers that deliver something to all the departments.

List the items delivered by Nepalese Corp. and sold in the Navigation department.

List the items delivered by Nepalese Corp. or sold in the Navigation department.

List the departments selling type E items that are delivered by Nepalese Corp. and/or sold by the Navigation department.

Find the average salary of the employees in the Clothes department.

Find, for each department, the average salary of the employees.

Find, for each department on the second floor, the average salary of the employees.

Find, for each department that sells items of type E, the average salary of the employees.

What are the number of different items delivered by each supplier that delivers to all departments that have sold any item?

Find the total number of items of type E sold by the departments on the second floor.

Find, for each item, the total quantity sold by the departments on the second floor.

List suppliers that deliver a total quantity of items of types C and N altogether greater than 100.

List the employees in the Accounting department and the difference between their salaries and the average salary of the department.

List the employees in the Accounting department and the difference between their salaries and the average salary of all employees.

What is, for each supplier, the average number of all items per department that the supplier delivers? Report the supplier's and department's name and average delivery.

For each department, find the average salary of the employees who earn more than the average salary of the department.

Give the overall average of the salaries in all departments.

List each employee's salary, the average salary within their department, and the difference between the employee's salary and the department average.

What is the average delivery quantity of items of type N delivered by each company? List the supplier's and item's name.

List the name of the supplier and department where the average delivery quantity of items of type N is given per supplier per department.

What is the number of supplier-department pairs in which the supplier delivers at least one item of type E to the department?

Is it true that all the departments that sell items of type C are located on the third floor?