Sopra Steria interview question

Data base table joining queries?