Shopee interview question

SQL in terms of left join