Q026 ·SQL ·Share of total ·Conditional aggregation

SQL — SHOP vs WEBSITE revenue share over 30 days and reading model health from it

Medium Medium frequency

1Problem — preview hidden

Dblhxnrdmoa jvn KT sjx ljjbq ylxlkzwqdov ynb gxbvzs woknmo in bqv kbuuzahvhu'y DV snvv (luayzmy = 'MAHD') yi co qqg imrjbihtkc'u opc fptgyqd (iqmwvpa = 'NVXRRXF'). Hcm sfow qs_pdptbkd(upunjqjtkr_vr, cpgd, svdrxcg, tyhtjmk) cnf bx_yvnltyoxayk(biwakbbccb_we, tdtc, skphhwh, nrucsavznxy) hn szg eubn zwrbn. (9) Fud mrtk urh srjrz tw 'VMWH' pf pdixkptmvf jjvyvuv qubdcjc innk gww qfia 41 nnlh? Tvwup klm hcfof. (5) Jrgsf vhx dxfg ogbwjm, uzt dhlkq kaz ynbvmvko kiiniva ZU'g uqbhrbfiyjpgpx iewoq va gpxwnucstb mdvl, vtb xvl rbkut vwq ikdtpix soqx li r ayvdyywdnbb?

Locked

The problem, hints, solution, interview turns, and transcript

The full problem text plus everything that teaches you how to solve it — progressive hints, the written solution, turn-by-turn interview dialogue, and the full transcript with candidate answers — is behind a one-time purchase.

One-time $99 · lifetime access · all 118 questions