Basic to Complex SQL Server queries with Adventure Works database including window functions, triggers, string manipulation, user-defined functions, CTE, recursive CTE, DML and DDL
-
Updated
Jul 22, 2022 - TSQL
#
windowfunction
Here are 5 public repositories matching this topic...
This Repository Contains a collection of SQL Scripts demonstrating various analytical techniques, such as changes over time, cumulative, performance, part-to-whole anlaysis.
-
Updated
Jul 3, 2025 - TSQL
Collection of SQL query solutions for LeetCode challenges.
schema sql database etl data-analysis cte conditional-statements query-optimization pivot subquery windowfunction tsql-stored-procedures unpivot t-sql-scripts joins-aggregation setoperators
-
Updated
May 16, 2026 - TSQL
This project cleans and prepares a layoffs dataset using SQL by removing duplicates, standardizing text, handling null/blank values, and dropping unnecessary columns. The result is a consistent, high-quality dataset ready for reporting, analysis, and visualization.
sql dml data-analysis mssql cte sqlserver dataanalysis windowfunction datacleaning dml-commands windowfunctions
-
Updated
Sep 24, 2025 - TSQL
Data analysis project using SQL to explore pizza sales data, applying joins, aggregations, subqueries, and window functions to generate actionable business insights.
-
Updated
Apr 21, 2026 - TSQL
Add this topic to your repo
To associate your repository with the windowfunction topic, visit your repo's landing page and select "manage topics."