Shopee Interview Question

SQL in terms of left join