UKG Interview Question

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