ZS Associates interview question

SQL, Merging dataframes, basic consulting stuff