Ramco Systems Interview Question

SQL join question, project, some other queries