Set operations
Exercise · SQL & Querying

Predict, then run it

Predict the output

log_a(tech, building) = (Ada, North Tower). log_b(building, tech) = (South Tower, Ben) — the legacy log lists its columns swapped. Aligned by position:

SELECT tech, building FROM log_a UNION ALL SELECT tech, building FROM log_b ORDER BY tech;

Predict the exact output.