Atos interview question

Write sql join query. Spark Query Inner Join Outer Join