DSP-112Product DSSQL
Find the top 1% customer by cumulative revenue(需要 window function)
📋 题目详细背景与场景
3) Find the top 1% customer by cumulative revenue (需要用window function 这里我有个bug 把order by 写成partition by了)
📖 对应核心知识点手册:
想用苏格拉底式对话深入理解该考点的第一性原理?
进入破冰推演实验室,模拟考官互动并一步步拆解底层机制与直觉陷阱。
⚡
Test muscle memory on this topic via 3-Layer Flashcards
Active Recall: Mentally formulate Prompt ➔ Math Derivation ➔ Benchmark Implementation in 3 minutes.