Restricting and Sorting Data

Using the WHERE clause Using comparison and NULL condition Using Logical condition using AND, OR, and NOT operators Rules of precedence for operators in an expression Using ORDER BY clause for sorting