Shopee Interview Question

Why do you use this SQL codes to execute? can you use something else?