Part A $($Queries$)$

Save the queries as Query$1,$ Query$2...$ Note that you may need to modify the SQL view for some of these queries.

Design a query to list the ID$,$ first name, and last name of employees who earn more salary than their supervisor and the amount by which the employee's salary is higher.

Design a query to enable the user to enter the name of a product and list the ID and product names of products having a different Quantity Per Unit from that of the product entered.

Design a query to enable the user to enter the first name and last name of an employee and list the ID$,$ first name, last name, and hire date of all employees hired within two years after the employee entered was hired. For example, if the name entered was hired on March $20,2019,$ all employees hired from then up until March $20,2021,$ must be listed.

Design a query to list all Customer IDs, the Order ID of the orders they have submitted $($if any$),$ and the employee ID that handled the order. All employees $($including those who have never handled an order$)$ and all customer IDs $($including those who have never submitted an order$)$ must also be listed. The list must be ordered in ascending order of the employeelD, and then in ascending order of the orderID $($if the employee is listed more than once$).$ A sample of the expected result from a different dataset is provided below: Customer ID ABCD has never submitted an order and employee ID $55$ and employee ID $4$ have never handled an order.

$\backslash$table$[[$CustomerID$,$OrderID,EmployeeID$],[$ABCD$,,],[$DCBA$,11231,1],[$DCBA$,10101,2],[$EBAC$,11123,2],[,,4],[,,55]]$

$$