Python quizzes: #window-functions

2 quizzes about #window-functions, with an explanation for every answer.

4 ROW_NUMBER, RANK & DENSE_RANK Hard Number and rank rows with window functions and know exactly how each one treats ties. SQL · Subqueries & Window Functions #window-functions#ranking 10 questions · ~8 min Not started Start
5 Running Totals, LAG & LEAD Hard Build running totals, moving averages and row-to-row comparisons with window frames, LAG and LEAD. SQL · Subqueries & Window Functions #window-functions#running-totals 10 questions · ~8 min Not started Start

Other tags: