Elsevier Interview Question

Writing a SQL query related to inner join