GreyOrange interview question

SQL left and right join question Questions about my project