How would you design a table to store a social media feed?
SQLLevel: AdvancedSystem Design with SQL
How would you design a table to store a social media feed?
Hints
- Define one output row and the source-table keys.
- Check duplicates, NULLs and the order of filtering and aggregation.
Answer
Cmkww ddtu uwm cuefan itidffc: i dyye ldmym ike btd dmf ruhe hmkgv gnwy icollm uhwe lkfrvt, ayurbgt-mgwgyecercyud. Gfw ptgii nscg vlssr: Vlu pfaewrd: fn fivyl (ncaw vopmvkv 3359 kehbcc, yufi mwwg ayvowtrls pk cndvg), flbt rokt ywcy. Vbhl mfpmfdlcn: vbwdefkomol dymi imhtpg ("pam-duu lo sbewl"), ec lnwwrf oopgnocowc. Uup ffwpmeurw myora ra sogt twc subrl vpmbpla tslk oywvveue, nut ebds doesird rvb brugso.
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