List the customer number the name first and last and

This preview shows page 3 - 6 out of 7 pages.

List the customer number, the name (first and last), and the balance of customers who reside inColorado (CustState is CO).
SELECT CustNo, CustFirstName, CustLastName, CustBalFROM CustomerWHERE CustState = 'CO'List all columns of the Product table for products costing more than $50. Order the result byproduct manufacturer (ProdMfg) and product name.
List the order number, order date, and shipping name (OrdName) of orders sent to addresses inDenver or Englewood.SELECT OrdNo, OrdDate, OrdNameFROM OrderTblWHERE OrdCity IN ('Denver', 'Englewood')List the customer number, the name (first and last), the city, and the balance of customers whoreside in Denver with a balance greater than $ 150 or who reside in Seattle with a balance greaterthan $300.SELECT CustNo, CustFirstName, CustLastName, CustCity, CustBalFROM CustomerWHERE (CustCity = 'Denver' AND CustBal > 150) OR (CustCity = 'Seattle' AND CustBal > 200)List the cities and states where orders have been placed. Remove duplicates from the result.
List all columns of the OrderTbl table for Internet orders placed in January 2007. An Internetorder does not have an associated employee.
FROM OrderTblWHERE OrdDate BETWEEN #2/1/2007# AND #2/28/2007# AND EmpNo IS NOT NULLList all columns of the Product table that contain the words Ink Jet in the product name.Access SQL solution:SELECT *FROM ProductWHERE ProdName LIKE 'Ink Jet'List the order number, order date, and customer number of orders placed after January 23, 2007,shipped to Washington recipients.
List the order number, order date, customer number, and customer name (first and last) of ordersplaced in January 2007 sent to Colorado recipients.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture