UNION Combining Queries
Intermediate
Active users live in users; people who closed their account were moved to archive_users (same columns). Cara exists in both tables because she was copied rather than moved.
Write a query returning id, name and email of everyone from either table, with exact duplicate rows listed only once.
Constraints
- Columns, in order:
id,name,email - Combine both tables into one result
- A row present in both tables appears once
Hints
Hint 1
UNION stacks the results of two SELECTs.
Hint 2
Both SELECTs must return the same number of columns, in compatible types.
Keywords
db
SQL
Run your code to see results
No results yet
Run your code to check it against the examples, or submit to run every test.