Get startedGet started for free

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!

This exercise is part of the course

SQL Tutorial for Marketers

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise