UKG interview question

Some Sql queries based on the concepts of joins and basic sql functions.