window-functions

This repository contains a collection of SQL scripts demonstrating various analytical techniques, such as changes over time, cumulative, performance, data segmentation, part-to-whole analysis.

Advanced SQL workbook: subqueries, window functions, CTEs, recursive CTEs, and datetime practice.

#8WeekSQLChallenge, https://8weeksqlchallenge.com: Solutions for SQL Case Studies

SQL practice repository covering data analysis, joins, aggregations, window functions, and real-world query solving for data engineering and analytics.

SQL Engineeering Handbook by Mohammad Ammar . Production-ready with SQL tutorials, interview questions, real-world projects, query optimization, window functions, and analytics engineering examples. Created by the Co-Founder of Apex Analyticx . Live Portfolio : https://theammarngp.lovable.app

A professional SQL project demonstrating the core concepts of MySQL Window Functions, including ranking, running totals, and comparing values across related rows.

A comprehensive collection of 50 optimized SQL solutions for the LeetCode SQL 50 study plan, covering fundamental to advanced database querying concepts like Joins, Subqueries, and Window Functions.

Проекты курса Инженер данных на платформе Yandex Practicum

💸 Bitcoin trading analysis

SQL projects using the different functions from basic to advance

HR analytics pipeline: 30 employees · 5 departments · $58K–$135K salary range. PostgreSQL + SQL (CTEs, window functions) + Python + Tableau. Sales dept leads at $102K avg.

Retail analytics pipeline: 2,314 customers · 5,000 transactions · $2.58M revenue. PostgreSQL + SQL (CTEs, window functions) + Python + Tableau + Excel.

Advanced SQL in MySQL 8.0: window functions, pivot tables, regex, stored procedures, employee management project, ML data prep

SQL database design in PostgreSQL: normalization (1NF→3NF), ERD diagrams, subqueries, window functions, indexing and query optimization

Coleção de queries PostgreSQL | CTEs, window functions, índices, EXPLAIN ANALYZE e isolamento multi-tenant

Selected subset of Win (user32, shell32) API function calls for Window, Taskbar, etc handling, conveniently organized and wrapped in a C# DLL

从零开始，16 课掌握 SQL。每课有完整建表+插入+查询示例，可直接复制到 SQLite/MySQL 运行。涵盖 CRUD、聚合、多表查询、子查询、索引、事务、存储过程、SQL 注入防御、窗口函数，最终完成博客系统实战。From SELECT to a blog system in 16 lessons.

A TypeScript library for digital signal processing and audio analysis.

SQL analysis of Olist Brazilian e-commerce data using MySQL — sales, customer behavior, and delivery performance.

SQL case studies on real-world domains E-Commerce, HR Analytics, Hospital Management, and Banking. Covers joins, aggregations, subqueries, window functions, and CTEs.