WHERE AND OR (2)

You now know how to select rows that meet some but not all conditions by combining AND and OR.

For example, the following query selects all details from bank clients that are either 29 or 41 years old and that hold degrees from either university or high school.

SELECT *
FROM clients
WHERE (age = 29 OR age = 41)
AND (education = 'university degree' OR education = 'high school');

Now you'll write a query to get the job and age of bank clients that that are married, that don't have an unknown or no housing loan, and that have had a 6-year or 9-year basic education.

It looks like a lot, but you can build the query up one step at a time to get comfortable with the underlying concept in each step. Let's go!

Get the job and age for clients that are married.

Exercise

WHERE AND OR (2)

Instructions 1/3