STMicroelectronics Interview Question

SQL Query question for Left Outer Joint