9 12 Repeat problem 9 using the MINUS keyword. Note that Access does not support the MINUSkeyword. If the problem cannot be formulated in this manner, provide an explanation indicatingthe reason.
be formulated in this manner, provide an explanation indicating the reason.
9 14 Repeat problem 13 using a Type I nested query with a NOT IN condition instead of a nested query.If the problem cannot be formulated in this manner, provide an explanation indicating the reason.(Hint: you need to think carefully about the effect of null values in the OrderTbl.EmpNo column, iAccess SQL:SELECT EmpNo, EmpLastName, EmpFirstNameFROM EmployeeWHERE EmpPhone LIKE '(720)*' AND EmpNo NOT IN ( SELECT EmpNo FROM OrderTbl WHERE EmpNo IS NOT NULL)List the customer number, the name (first and last), and the balance of customers.