Include both internet no employee and phone orders

This preview shows page 2 - 4 out of 7 pages.

in the product name. Include both Internet (no employee) and phone orders (taken by anemployee).Access SQL: SELECT Customer., Employee.FROM Customer LEFT JOIN Employee ON Customer.CustFirstName = Employee.EmpFirstName AND Customer.CustLastName = Employee.EmpLastName UNION SELECT Customer., Employee.FROM Customer RIGHT JOIN Employee ON Customer.CustFirstName = Employee.EmpFirstNameAND Customer.CustLastName = Employee.EmpLastNameUsing a Type II nested query, list the customer number and name of Colorado customers whohave not placed orders in February 2007.Access SQL:SELECT Customer.CustNo, CustFirstName, CustLastNameFROM CustomerWHERE CustState = 'CO' AND NOT EXISTS( SELECT *FROM OrderTbl WHERE OrdDate BETWEEN #2/1/2007# AND #2/28/2007#AND OrderTbl.CustNo = Customer.CustNo )Repeat problem 9 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.Access SQL:SELECT Customer.CustNo, CustFirstName, CustLastName FROM Customer WHERE CustState = 'CO' AND CustNo NOT IN( SELECT CustNo
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.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture