STMicroelectronics interview question

SQL Query question for Left Outer Joint