Tredence interview question

2 question of SQL : easy and hard