SQLite Forum

Equivalent to:

~~~~
   WITH personList(concept_ID) AS (VALUES(1),(2),(3))
   SELECT count(*) FROM person
    WHERE person_ID IN (SELECT person.person_ID FROM personList)
      AND age > 30;
~~~~

Also works with PostgreSQL