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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
