DataGear Interview Question

question about inner join