On January 21th at 14:15 UTC , progression through exercises will be unavailable for 10 minutes due to a planned maintenance break.
Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close


That's right. Keep it up! Do you still remember subqueries, then? Let's see.

prison (id, name, country)

prisoner (id, prison_id, name, age)

The tables represent some of the most dangerous prisons in the world and a few fictional prisoners who serve their sentences there.

Each prison has an id, its name, and the country where it's located. Each prisoner also has an id, the id of their prison, a name, and a specific age.


Show all columns for the prisons where there is at least one prisoner above 50 years of age.

Stuck? Here's a hint!

Use the following template to help you build your query:

FROM ...
  FROM ...
  WHERE ...
    AND ...