UNION vs UNION ALL | Dataford Interview Questions

Explain the difference between UNION and UNION ALL.

Asked in the Conceptual questions stage. Using the provided orders table, demonstrate the distinction by combining cities from delivered and returned orders.

Output

One column named city.
Include cities found in either order status.
Return each city once, ordered alphabetically with NULL last.

Schema

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
customer_id	INT	Customer identifier
city	VARCHAR(100)	Customer delivery city
order_status	VARCHAR(30)	Current order status

Your question is UNION vs UNION ALL. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem