Pregunta de entrevista de Netcracker Technology

2 DB tables are given, write a JOIN query