![]() Where O.CustNo = C.CustNo AND O.OrdDate >= '' AND O.OrdDate '12/31/200' AND O.OrdDate 200ġ0. ![]() ![]() Select O.OrdNo, O.OrdDate, C.CustNo, C.CustFirstName, C.CustLastName List the order number, order date, customer number, and customer name of orders placed in February 2001 by Colorado customers but sent to Washington recipients. List all columns from the product table that contain the word "printer" in the product name.Ĩ. Where EmpNo IS NULL AND MONTH(OrdDate) = 1 AND YEAR(OrdDate) = 2001ħ. List all columns from the order table for internet orders placed in January 2001. List the cities and states where orders have been delivered. Where (CustCity = 'Denver' AND CustState = 'CO' AND CustBal > 150) OR (CustCity = 'Seattle' AND CustState = 'WA' AND CustBal > 300)ĥ. Select CustNo, CustFirstName, CustLastName, CustCity, CustBal List the customer number, name, city, and balance of customers who reside in Denver, CO with a balance of more than $150 or who reside in Seattle, WA with a balance greater than $300. Order the result by product manufacturer and product name.Ĥ. List all columns of the product table for products costing more than $50. Select CustNo, CustFirstName, CustLastNameģ. List the customer number, name, and balance of customers who reside in Colorado (CO). Select CustNo, CustFirstName, CustLastName, CustBalĢ. ![]() List the customer number, name (first and last), and balance of customers. For the more complex queries, alternative answers which return the correct results may be given.Ĭomplete all of the following (2 points each):ġ. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |