Ramco Systems interview question

SQL join question, project, some other queries