6.15. SQL Select Subquery

  • IN (SELECT ...) - subquery

6.15.1. Subqueries

SELECT *
FROM astronauts
WHERE agency IN (
    SELECT name FROM agencies);
SELECT *
FROM astronauts
WHERE career IN (
    SELECT name FROM job_names);
SELECT *
FROM logs
WHERE level in (

    SELECT level
    FROM logs
    GROUP BY level
    HAVING COUNT(*) > 5

);