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.