Practice:

certain criteria. Filter records SELECT FROM Practice 1. Create a query that will return only the Inventory_Description and Price from the Inventory table. 2. Create a query that will show only the Order_date and CustomerID from the Sales Orders table. 3. Create a query that will show the City and State from the Customers table. The next two SQL clauses are WHERE and ORDER BY. They follow FROM, to make a query in this order: SELECT FROM WHERE ORDER BY eturn all ted in the WHERE Jeremy Jones is included in this output. SELECT FROM WHERE Practice 1. Write a query that will return all of the records from the Sales Orders table that have a 2. Write a query that will return all of the records from the Sales Orders table that have a quantity less than or equal to 3. han $1,000 quantity greater than 4. exactly one item on it. Write a query that will return all of the records from the Sales_Orders table that had Write a query that will return all of the records from the Customers table of the 5. Write a query that will return all of the records from the Customers table of the customers from Baton Rouge. customers from Texas. Introduction to ORDER BY In Exhibit 4A.7, when Jeremy Jones was added to the output, you might have been surprised that the order of the records didn't change. The default order of SQL queries is ascending hased on the first column selected. When you SELECT *