5. Shaping Data with the WHERE Clause

Activity 5.01: Combining Conditions to Extract Store Data

Solution:

1. First, enter the SELECT statement. This is used so as to display the results using the requested column names:

   SELECT   
       ProductName as 'Product Name',  
       NetRetailPrice as 'Product Retail Price', 
       AvailableQuantity as 'Available Quantity'    
   From Products   
   WHERE NetRetailPrice <= 24.99   
       AND AvailableQuantity >=38  

2. Execute the query, you should get the following output in the result grid:

Figure 5.19: Columns from the Customers table