SQL Case Studies solved using Microsoft SQL Server and PostreSQL
sql microsoft-sql-server aggregate-functions window-functions case-statement common-table-expressions
-
Updated
Jan 23, 2024
#
common-table-expressions
Here are 16 public repositories matching this topic...
Sort: Most stars
Sort options
This project analyzes e-commerce order fulfillment using Advanced SQL Techniques and Python-based visualization to uncover insights on sales trends, customer segmentation, shipping cost optimization, and payment preferences.
data-visualization indexing partitioning database-design business-analytics customer-segmentation normalization-techniques common-table-expressions window-functions-in-sql
-
Updated
Feb 15, 2025 - HTML
An Advanced SQL Analytics Project demonstrating end-to-end data analysis using SQL β from EDA and ADA to data transformations and final business reports. Includes two analytical views summarizing Customer and Product performance with insights on revenue, trends, and growth.
sql exploratory-data-analysis business-intelligence data-analysis sqlserver tsql ssms common-table-expressions window-functions-in-sql subqueries-and-joins
-
Updated
Sep 27, 2025 - TSQL
A SQL project to analyze music store data. Find the results of given data with the help of answering the questions using queries.
-
Updated
Mar 5, 2024
data-modeling-analysis-sql
sql data-analysis joins data-modeling aggregate-functions sub-queries common-table-expressions window-functions-in-sql
-
Updated
Jan 8, 2024
A Tableau dashboard showing the best hotel prices for places with ratings of 7.0 or greater.
-
Updated
Mar 2, 2023
Built a Data Model, Implemented Basic to Advanced SQL Queries
instagram sql postgresql joins datamodel aggregate-functions common-table-expressions window-functions-in-sql
-
Updated
Jan 12, 2024
Answering ad-hoc business questions about Rockbusterβs film inventory, customer data, and payment records to support their transition to an online video rental service.
data-dictionary relational-databases data-cleaning subqueries entity-relationship-diagram filtering-data common-table-expressions database-querying data-summarizing joinging-tables
-
Updated
Apr 17, 2024 - SQL
This project demonstrates a comprehensive data warehousing and analytics solution, from building a data warehouse to generating actionable insights. Designed as a portfolio project, it highlights industry best practices in data engineering and analytics.
views sql sql-server sql-query sql-injection common stored-procedures common-table-expressions window-functions-in-sql
-
Updated
Jul 1, 2025 - TSQL
This project involved analyzing data for Rockbuster Stealth LLC, a fictional movie rental company transitioning to an online video rental service.
-
Updated
Sep 5, 2024
This project documentation was developed as a free project, as a data analyst from the fictional company Sell Boardgames would do in his daily work.
python sql sql-server etl backup-script data-analysis dax powerbi datawarehouse stored-procedures powerpoint-presentations slowly-changing-dimensions reporting-services staging-area integration-services star-schema analysis-services data-vizualization abc-analysis common-table-expressions
-
Updated
Aug 29, 2023 - TSQL
LeetCode SQL 50
select sql leetcode regex regexp leetcode-solutions cte joins datetime-format clause subqueries practice-exercises aggregate-functions window-functions structured-query-language common-table-expressions window-functions-in-sql sorting-and-grouping advanced-select-and-joins advanced-string-functions
-
Updated
Apr 16, 2025
Explores an E-Commerce dataset and generate various analytics and insights from customers' past purchase behavior.
rfm-analysis tableau-dashboards windows-function aggregate-functions sub-queries common-table-expressions sql-xml-path-function
-
Updated
Mar 22, 2023
A comprehensive IMDB dataset analysis using SQL. Includes database setup, advanced queries, and actionable insights. Organized with files for database creation, queries, and solutions. Features an Entity-Relationship Diagram (ERD), executive summary, and SQL scripts. Perfect for SQL workflows and business intelligence in the film industry.
sql business-intelligence data-analysis relational-database database-design imdb-dataset entity-relationship-diagram data-driven-decisions data-querying aggregate-functions common-table-expressions subqueries-and-joins
-
Updated
Nov 23, 2024
A structured SQL analysis of Major League Baseball (MLB) data using analytical queries and window functions.
-
Updated
Jul 28, 2025
π Explore raw data through SQL for deep analytics, transforming insights into final reports on customer and product performance.
data-science data query statistics sql-server advance reporting tutorials data-engineering business-intelligence data-analytics predictive-modeling data-analyst business-analytics learning-resources window-functions common-table-expressions subqueries-and-joins
-
Updated
Oct 25, 2025 - TSQL
Improve this page
Add a description, image, and links to the common-table-expressions topic page so that developers can more easily learn about it.
Add this topic to your repo
To associate your repository with the common-table-expressions topic, visit your repo's landing page and select "manage topics."