Evita — SQL Window Functions for Analyst Interviews
SQL window functions for analysts who still export to Excel, marked 1:1 against a real orders and customers schema. Five sessions on partitions, frames, rank versus dense rank and lag, ending when you answer eight interview questions in under ten minutes each.
How do I write SQL window functions for running totals and rank?
SQL window functions for analysts who still export to Excel, marked 1:1 against a real orders and customers schema. Five sessions on partitions, frames, rank versus dense rank and lag, ending when you answer eight interview questions in under ten minutes each.