Tredence interview question

CTE expressions, Basic joins (SQL)