AVASOFT Interview Question

SQL queries with joins in easy level