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

Exercise

Filtering Numeric Records

As you saw in the example that was included in the previous exercise, the WHERE clause can be used to filter numeric records, such as years or ages.

Now it's your turn to construct a query with the WHERE clause to filter numeric values!

Instructions 1/3

undefined XP
  • 1

    Get all details for all campaigns with a duration smaller than 200 seconds.

  • 2

    Get the number of campaigns that lasted for less than 200 seconds.

  • 3

    Get the client identification number and duration of contact that lasted less than 200 seconds.