Home
/
Questions
/
Coding
/
Trial-site enrollment rollup
caseSQL
Coding question · Recursive Cte
Very Hard
Asked at Veeva Systems
Trial-site enrollment rollup
Recursive CTE over self-referential hierarchy + LEFT JOIN rollup.
Unlock with Pro
→
Back to all coding questions
The Brief
← Previous
Shortest-path depth from node 1
Next →
Top 3 debits per customer (DENSE_RANK)