window-functions

Star

Here are 124 public repositories matching this topic...

Language:All

Filter by language

All124 TSQL22 Jupyter Notebook13 Python7 PLpgSQL4 SQL2 ANTLR1 C1 C#1 HTML1 Haml1

Sort:Most stars

Sort options

Most stars Fewest stars Most forks Fewest forks Recently updated Least recently updated

DataWithBaraa /sql-data-analytics-project

Sponsor

Star119

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.

data-science data query sql sql-server database analytics reporting sql-query datascience data-engineering business-intelligence data-analytics data-analysis data-analyst sql-queries business-analytics data-scientist window-functions window-functions-in-sql

UpdatedMar 26, 2025
TSQL

muryulia /8-Week-SQL-Challenge

Star42

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

postgres sql postgresql data-analytics case-study sql-challenges window-functions data-with-danny 8weeksqlchallenge 8-week-sql-challenge

UpdatedApr 25, 2022

ndleah /bitcoin-prices-analysis

Sponsor

Star8

💸 Bitcoin trading analysis

data-science sqlite data-analysis window-functions data-expl

UpdatedSep 14, 2021
SQL

SergeySenigov /data-engineer-practicum-portfolio

Star7

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

python bash docker kubernetes redis airflow sql kafka spark mongodb helm jupyter-notebook spark-streaming dwh vertica kctl window-functions cloudbeaver hdfs-hadoop mpp-databases

UpdatedMay 27, 2025
Python

ellaclauz /SQL-FOR-DATA-ANALYSIS

Star6

SQL projects using the different functions from basic to advance

sql postgresql aggregate-functions window-functions sql-data-cleaning

UpdatedMar 23, 2023

etfovac /WinAPI

Star5

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

csharp dll winapi taskbar wrapper-api window-functions

UpdatedDec 20, 2020
C#

MaxLopezSalgado /sql-playground

Star3

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.

queries sql cet conditional-statements subqueries window-functions

UpdatedJun 12, 2023

eurora-labs /ferrous-focus

Star3

Cross-platform focus tracker for Linux (X11), macOS and Windows

desktop-app monitor monitoring desktop desktop-application focus focus-management window-functions window-focus

UpdatedNov 1, 2025
Rust

rahkum96 /Olympics-Dataset-by-sql

Star2

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

sql power-query data-cleaning subqueries aggregate-functions window-functions temp-tables

UpdatedJan 11, 2022

Gino-Freud-Hobayan /8WeekSQL_Challenge

Star2

SQL Case Studies solved using Microsoft SQL Server and PostreSQL

sql microsoft-sql-server aggregate-functions window-functions case-statement common-table-expressions

UpdatedJan 23, 2024

franckbinde /dannys_diner

Star2

SQL Challenge

sql joins common-table-expression window-functions

UpdatedSep 4, 2022

SA01 /spark-window-functions

Star2

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

big-data spark analytics data-engineering spark-sql window-functions

UpdatedOct 28, 2024
Python

Gopalkholade /Pizza-Sales-Analysis-with-SQL

Star1

Pizza Sales analytics with sql

mysql sql window-functions

UpdatedMay 9, 2024

osmanovabm /sql-data-analytics-project

Star1

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

sql analytics reporting postgresql data-analytics cte window-functions

UpdatedAug 28, 2025

Jaswin-J /Film-Rental-Analysis

Star1

Creating Report for decision making in Film Rental Store

mysql sql dml ddl data-analysis structured-data joins aggregate-functions dql-commands window-functions

UpdatedMar 13, 2024

Ankush-Santra /SQL_Projects

Star1

This repository showcases a curated collection of my SQL projects, demonstrating skills from foundational concepts like SELECT, INSERT, and ALTER to advanced techniques such as CTEs and Window Functions.

sql postgresql visual-studio-code union cte postgresql-database joins sql-queries subqueries window-functions date-functions

UpdatedJan 19, 2025

dannydave /sql-data-analytics-project

Star1

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.

data-science data query sql sql-server reporting sql-query datascience data-engineering business-intelligence data-analytics data-analysis data-analyst sql-queries business-analytics data-scientist window-functions window-functions-in-sql

UpdatedAug 9, 2025
TSQL

neha-dev-dot /Pyspark-Tutorial

Star1

This repository is part of my journey to learn **PySpark**, the Python API for Apache Spark. I explored the fundamentals of distributed data processing using Spark and practiced with real-world data transformation and querying use cases.

transformations actions dataframes sparkcontext rdds udfs window-functions pyspark-sql data-partitioning sparksession sparkbasics pyspark-basics