QSALE Table

QITEM Table

QDEL Table

QSPL Table

QDEPT Table

QEMP Table

For these questions, place the answer in red below the question, and copy & paste the result set from the query.

A) Write the necessary SQL code to find the name of the highest-paid employee in the Purchasing department.

B) If Nancy's boss has a boss, who is it? Write the necessary SQL code to find out.

C) Write the necessary SQL code to find the brown items sold by the Books department and delivered by All Points_ Inc. Remove duplicates.

D) Write the necessary SQL code to find all the Khaki colored items that have been delivered, but for which there have been no sales. Do not include any duplicate and sort by descending order of item name.

QSALE QITEM *saleno saleqty *itemname itemtype itemcolor QDEPT QDEL QSPL *deptname deptfloor deptphone *delno delqty *splno splname department of boss boss of department QEMP *empno emptname empsalary employee of boss boss of employee QSALE QITEM *saleno saleqty *itemname itemtype itemcolor QDEPT QDEL QSPL *deptname deptfloor deptphone *delno delqty *splno splname department of boss boss of department QEMP *empno emptname empsalary employee of boss boss of employee