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.

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

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

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

💸 Bitcoin trading analysis

SQL projects using the different functions from basic to advance

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

This project is a SQL database management system that handles multiple tables and performs various queries and operations on them. It involves four different tasks, each with its own set of tables and questions to solve. The tasks cover a range of scenarios, that allow to apply basic, intermediate and advance SQL queries to different datasets.

A Godot addon node that maps a Window accurately into 2D world space, with full control both ways.

8 Week SQL Challenge solutions — MySQL solutions for 7 case studies (Danny Diner to Balanced Tree). Covers window functions, 10-CTE funnels, market basket self-joins, and percentile calculations.

SQL Case Studies solved using Microsoft SQL Server and PostreSQL

This repository contains the code and examples for my article on Medium, which provides an introduction to Window Functions in Apache Spark.

SQL Challenge

120 years of Olympic history: athletes and results from basic biodata on athletes and medal results from Athens 1896 to Rio 2016.

SQL-based analysis of Apple retail sales data to uncover insights on sales trends, product performance, and warranty claims using large-scale datasets.

Advanced SQL analytics demonstrating window functions, CTEs, and cumulative calculations — techniques directly applicable to financial services reporting.

This repository showcases an SQL data analytics project demonstrating Exploratory Data Analysis (EDA) and Advanced Analytics (CTEs, Window Functions, Subqueries, Views) in PostgreSQL.

HR analytics using advanced SQL | Window functions, CTEs, views, indexing | Optimized for dashboard consumption | MySQL

Creating Report for decision making in Film Rental Store

End-to-end SQL analytics project built in PostgreSQL analysing shipment performance and carrier reliability for a Dubai-based freight forwarder across GCC, South Asia, and East Africa corridors.