Advanced SQL workbook: subqueries, window functions, CTEs, recursive CTEs, and datetime practice.
-
Updated
Jan 11, 2026 - HTML
Advanced SQL workbook: subqueries, window functions, CTEs, recursive CTEs, and datetime practice.
SQL Data Analysis project exploring the Netflix dataset using MySQL, featuring data cleaning, CTEs, window functions, joins, and business insights.
OlistIQ: End-to-End SQL Analytics on 100K Brazilian E-Commerce Orders — Schema Design, ETL Pipeline, RFM Segmentation, Delivery SLA Intelligence & Business Insights
Behavior-based fraud risk analysis of financial transaction data, using anomaly detection and engineered fraud metrics across transaction value, frequency, and login behavior to flag high-risk activity.
T-SQL Study — SQL Server 2019 interview prep: 28 leveled topics with definitions, runnable examples, edge cases & scenario Q&A for full-stack developers.
30 days · 90 drills · real SQLite in your browser with result-set grading. Free SQL interview practice for new grads & intern seekers.
Ejercicios prácticos de SQL intermedio con MySQL 8+: SELECT avanzado, JOINs, Agregaciones, CTEs, Subconsultas y Window Functions. Incluye soluciones y esquema de base de datos lista para usar.
30 analytical SQL queries on the Chinook database: multi-table joins, subqueries, window functions and CTEs
Production-grade SQL analytics on 100K-order Ash Stores e-commerce database using CTEs, window functions, and cohort logic. Features 15 analyses, RFM segmentation, and interactive dashboard.
SQL portfolio project analyzing 2,000 barbershop customer visits — customer segmentation, retention/churn, service revenue mix, and Pareto analysis using window functions, CTEs, and conditional aggregation in SQLite.
SQL-first analysis of the Olist e-commerce dataset in PostgreSQL: cohort retention, RFM, window functions, tested queries
FFT von Hand, sechs Fensterfunktionen, Leckeffekt und Aliasing - gegen Harris (1978) geprueft
Healthcare analytics portfolio: 36 SQL exercises on 7M+ rows across 17 tables. Window functions, recursive CTEs, risk scoring, revenue cycle analysis. $13.3B opportunity identified. Built with SQLite + Python + pandas
To associate your repository with the window-functions topic, visit your repo's landing page and select "manage topics."