Eli Lilly and Company Interview Question

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