1SELECT *
 2FROM
 3  (
 4    SELECT
 5      id,
 6      name
 7    FROM
 8      users
 9    WHERE active = TRUE
10  ) AS active_users
11WHERE name LIKE 'A%'