SyntaxPilot
Courses/Data Analytics with Python/Lesson 57
Video coming soonThis lesson’s video is being made

Start with the notes below; the video appears here as soon as it is on YouTube.

Data Analytics with Python · Lesson 57 of 90

SQL for analysts 2: CTEs, window functions and DuckDB

CTE (WITH)subqueryCASE WHENwindow functionOVERPARTITION BYROW_NUMBERLAGrunning total in SQLDuckDBquerying DataFrames with SQLquery in Parquet files

Detailed notes for this lesson are being written. They appear here together with the video.