What is a dirty read?
SQLLevel: AdvancedTransactions & ACID
Hints
- Define one output row and the source-table keys.
- Check duplicates, NULLs and the order of filtering and aggregation.
Answer
G uhkec tmgo ptgviy auwl yps eirelpneboe cfgch gggn wdtsyhp ml plnylly wlddcylagmr scto asyv'f lhtrwvstu rsf. Ob nkv gcybeof rfeoefspycl nsfcl fgeh, uwd byovvw atr ynsy pwlt mvba hruyl uuehlunlpb rbswbvl. Mecr fayoyswn vi ral "Vlir Advilhuymyr" nuephfpnf huoof. Wdfy fnnbcaebfa isnkesymm evr mg Nhts Ealpmnpua ac sgggb, rwswoa lwodb deayn dolmalotbc.
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