Your file is available as data. Use standard SQL β window functions, CTEs, aggregates all work. Press Ctrl+Enter to run.
data
Ctrl+Enter