Topic
SQL basics
SELECT, WHERE, ORDER BY and the logic that hangs off them. These are the questions that decide whether the rest of an interview happens, and the usual failure isn't syntax — it's a filter that silently drops NULLs.
New to this? Read the SELECT: reading data chapter.
easyApplicants with no referral code on fileGXBank · basicsFree→easyCheapest flights to a destinationAirAsia · basicsFree→easyClassify e-wallet balances into tiersBoost · basicsFree→easyClassify insurance policies into tiersAIA · basicsFree→easyLabel moderation queue items by urgencyTikTok · basicsFree→easySelected routes, mid-range priceAirAsia · basicsFree→easyShipped or delivered orders worth over RM 100AEON · basicsFree→easyShow 'Unassigned' for branches without a managerRHB Bank · basicsBasic→easyWallets with a healthy balanceTouch 'n Go · basicsFree→mediumBuyers active in both January and FebruaryCarousell · basicsBasic→mediumCustomers with no way to reach themPublic Bank · basicsBasic→mediumEvery customer who has banked online or in a branchDBS Bank · basicsBasic→mediumLabel TNB bills as on-time, late, or unpaidTenaga Nasional · basicsFree→mediumPlayers who churned after JanuaryTencent · basicsBasic→