Accenture interview question

SQL joins, manual testing related