Pergunta de entrevista da empresa Eli Lilly and Company

SQL to join two tables and find out aggregate value, different b/w various joins and input vs output comparison