1SELECT * FROM (SELECT id, name FROM users WHERE active = true) AS active_users