Interview pack

Banking pack

Questions themed around Maybank, HSBC, AIA and GXBank — the joins, subqueries and window functions that come up in bank and insurer SQL screens.

easyApplicants with no referral code on fileGXBank · basicsFree→easyAverage balance by account typeGXBank · aggregationFree→easyClassify insurance policies into tiersAIA · basicsFree→mediumFive-year premium projectionNewAIA · mathFree→mediumTotal spend per customerMaybank · joinsFree→mediumAbsolute difference and relative liftNewMaybank · experimentationFree→