Output of Chaining Two INNER JOINs Across Customers, Orders and Products - AP Moller Maersk OA Question | OAHelper

Company: AP Moller Maersk

Difficulty: medium

Problem Statement

Output of Chaining Two INNER JOINs Across Customers, Orders and Products Consider the following three tables. Customers : CustomerID CustomerName 1 John 2 Mary 3 David Orders : OrderID CustomerID ProductID 1 1 100 2 1 101 3 2 102 4 3 103 5 3 104 Products : ProductID ProductName 100 Laptop 101 Smartphone 102 Tablet 103 Headphones 104 Camera Which output is generated by performing an INNER JOIN between Customers and Orders on CustomerID , and then an INNER JOIN between that result and Products on ProductID ?

More AP Moller Maersk OA questions Interview experiences