Drivestream interview question

About sql joins and basic functions