Shopee Interview Question

SQL, how to join tables, syntaxed