We'll cover how to filter rows with the WHERE clause, looking first at simple and complex conditions. We'll look into the special ways SQL can save us keystrokes and make our queries more readable, including using BETWEEN and IN. We'll also cover wildcards with LIKE.