Pergunta de entrevista da empresa Netcracker Technology

2 DB tables are given, write a JOIN query