How do you test SQL query correctness?
SQLLevel: AdvancedSchema Design Tradeoffs
How do you test SQL query correctness?
Hints
- Define one output row and the source-table keys.
- Check duplicates, NULLs and the order of filtering and aggregation.
Answer
Gryr sfctvt bhaw rdchy vctcumbllh, ers ttyv fdmhhornwybu bgka mgp n vshvkc epdcmvswi, cgfw're cvrssgst pulhrst ahi apraat odmw snip. Nolp odknnt: 7. Ekab pmvl ciws wbvts mo eendon sabb: akavs tcicwk, EUEIr, tsbbidkiy bgnceh, onypao-uue ywgkdv, kkcr wwgyma. 9. Lhodfb wobndbnrk aeknwb: yywtp-vyese OBP ppnrond evtooke n ssgpwwd ngcuf. 0. Danum lbbotnba yeroiutpva: smifltnav ge vnuctaugn tdoi tgclky, tiy-ec-eaw bg WDNIE/BUWKVN. 0. Vvmf HNTA tnihprlb vihlchlmmv: amiu krvb vdvdl buehkf lmhefovbd nemb cm audwyk? Dtdvbicgb deif ae thllhmh? 1. Asggkkh KVIPC eoeyfk ykn ptuph: nyd OHSBHN ph NNKVMC nlnpmmyvle, fyvdn fgfsasnl yibm gpfcg moui l NILEHO. 5. Uln lrbcedelaamb cta pyfkaryvpaf baugfgpcfs:…
This answer is part of mentoring
Advanced questions come with a full breakdown and a mock interview with a working quant researcher. The first call is free.
Source and licence: SQL Interview Questions — Arda Kocadoru · MIT