Tredence interview question

dwh concepts ,sql scenarios