Accenture interview question

Sql query from two table using joins