1. Learn
    2. /
  2. Courses
    3. /
  3. SQL Tutorial for Marketers

Exercise

WHERE AND

Filtering your records is already a good way of getting a more exact view on your data, but often, you'll want to select data from your tables based on multiple conditions.

As you saw in the beginning of this chapter, you can build up your WHERE queries by combining multiple conditions with the AND keyword.

For example, the query

SELECT *
FROM clients
WHERE age > 40 
AND education = 'university degree';

gives you a result set with all details from clients with a university degree and that are over 40 years old.

Note that you need to specify the column name separately for every AND condition! You can add as many AND conditions as you need :)

Instructions 1/3

undefined XP
  • 1

    Get all details for clients that are technicians and that are 30 years old or older.

  • 2

    Get all details for campaigns where clients where contacted via cell phone ("cellular") and that lasted longer than 200 seconds.

  • 3

    Get all details for campaigns where the duration of the contact was more than 200 seconds and which happened on Tuesdays in May.