Introduction
Very simple subqueries
6. Subqueries with various logical operators
Subqueries with multiple results
Correlated subqueries
Other subqueries

## Instruction

Excellent! Subqueries can also be used with other logical operators. Take a look at the following example:

SELECT
*
FROM mountain
WHERE height > (
SELECT height
FROM mountain
WHERE name = 'Zugspitze'
);


The above query will return all mountains which are higher than Zugspitze. As you can see, we've used the 'greater than' sign (>) together with a subquery.

## Exercise

Find the names of all cities have a population lower than Madrid.

### Stuck? Here's a hint!

Type:

SELECT
name
FROM city
WHERE population < (
SELECT
population
FROM city
WHERE name = 'Madrid'
);