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

Exercise

BETWEEN (2)

Similar to the WHERE clause, the BETWEEN clause can be used with multiple AND and OR operators, so you can build up your queries and make them even more powerful!

Take a go at using BETWEEN with AND on the clients data to get the job and marital status of all clients with ages between 20 and 50 years (inclusive) with no housing loans. We have broken the problem into smaller steps so that you can build the query as you go along!

Instructions 1/2

undefined XP
    1
    2

Get the job and marital status of all clients with ages between 20 and 50 years (inclusive).