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. |