Pregunta de entrevista de Corecard Software

Explain different SQL Join different between them with example of queries