In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

1. •

   Open an SQL script that contains a query with a WHERE clause that filters and an ORDER BY clause that sorts. (6 min)

2. •

   Experiment with sorting by multiple columns and comparing ascending and descending sorts. (7 min)

3. •

   Use the SQL WHERE clause to specify which rows to display as a result of an SQL retrieval query. (6 min)

4. •

   Combine filter criterion in a combination WHERE clause in an SQL query to limit the rows retrieved and displayed. (5 min)

5. •

   Combine multiple conditions in a combination WHERE clause in an SQL query to limit the rows retrieved and displayed. (5 min)