</>SkillRecallRECALL WHAT YOU KNOW
Explore Library
Databases & SQLWindow Functions

26 items

1

Window Functions for Feature Engineering

Flashcard
2

Window Functions Inside CTEs

Quiz
3

Windows for Feature Engineering

Slides / Video
4

Top Earner Per Department Bug

Code Quiz
5

Filtering on a Window Function Result

Code Quiz
6

Filtering on Window Function Results

Quiz
7

Window Functions With CTEs

Slides / Video
8

Filtering on Window Function Results

Flashcard
9

Percent-of-total With a Window Frame Bug

Code Quiz
10

Nesting Aggregates Inside Window Functions

Quiz
11

Cohort Retention Trend Bug

Code Quiz
12

Filtering On Window Function Results

Quiz
13

Running Total With Duplicate Dates

Code Quiz
14

Running Totals and Default Frames

Quiz
15

Cohort & Trend Analysis With Windows

Slides / Video
16

RANGE vs ROWS Default Frame Peers

Quiz
17

Default Frame: RANGE vs ROWS Gotcha

Flashcard
18

Window Functions & Advanced Aggregation

Slides / Video
19

Assigning Cohorts With Window Functions

Quiz
20

Window Functions for Cohort & Trend Analysis

Flashcard
21

Joins, Window Functions & CTEs

Slides / Video
22

Filtering on Window Function Results

Quiz
23

Combining CTEs, Joins & Window Functions

Flashcard
24

Window Functions & Query Performance

Slides / Video
25

Window Functions and Query Performance

Quiz
26

Window Functions & Query Performance

Flashcard
Flashcard

Window Functions for Feature Engineering

How window functions build predictive features like rolling stats and lagged values without collapsing rows.

Question

How do window functions engineer ML features while keeping row-level granularity?

Click to reveal answer