Save up to $499! Grab all Python courses for $49 or all online courses we’ve ever launched for only $169. Only Feb 11-16. Happy Valentine's!
Introduction
Very simple subqueries
Subqueries with multiple results
11. The ANY operator
Correlated subqueries
Other subqueries

Instruction

Good! To sum up this section, let's learn about one more operator: ANY. Take a look:

SELECT
  *
FROM Trip
WHERE Trip.Price < ANY (
  SELECT
    HikingTrip.Price
  FROM HikingTrip
  WHERE HikingTrip.MountainID = 1
);

In the above example, we want to find trips to the cities that are cheaper than any hiking trip to the mountain with ID 1 (Mont Blanc, just to let you know). There are two hiking trips to Mont Blanc: one that costs 1000 and one that costs 300. If we find a city trip that is cheaper than either of these hiking trips, we will show it in the result.

Again, other logical operator combinations are possible: = ANY, != ANY, > ANY, <= ANY, or >= ANY.

Exercise

Find all information about all city trips that have the same price as any hiking trip.

Stuck? Here's a hint!

Type:

SELECT
  *
FROM Trip
WHERE Trip.Price = ANY (
  SELECT
    HikingTrip.Price
  FROM HikingTrip
);