Asset Analytix interview question

Joins and Union SQL and DB