Hexaware Technologies Interview Question

state inner join sql query?