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 · aggregationBasic→easyClassify insurance policies into tiersAIA · basicsFree→mediumFive-year premium projectionAIA · mathBasic→mediumTotal spend per customerMaybank · joinsBasic→mediumAbsolute difference and relative liftMaybank · experimentationFree→mediumAccounts above their own branch's averageHSBC · subqueryBasic→hardRank customers by spendMaybank · windowBasic→hardRank customers by transaction amount, per branchHSBC · windowBasic→

Company names are trademarks of their respective owners, used here only to describe practice material. mahir_data is not affiliated with, endorsed by, or sponsored by any company named on this site. Terms.