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.