sql-aggregation 开源项目推荐（15 个）

maf345 /sql-hands-on

This repository contains SQL queries from various popular online learning resources e.g. Vertabelo Academy, SQLZoo etc.

jgperrin /net.jgp.books.spark.ch15

Spark in Action, 2nd edition - chapter 15 - Aggregating your data

salsabila-rahmah /SQL-Based-Data-Preparation-and-Validation-for-BI-Analysis

This project uses SQL to transform messy transactional sales data into a clean, validated dataset for accurate KPI and profitability analysis before BI reporting. I also built a Tableau Public dashboard from this final dataset; it can be viewed via the link below.

AlaaNabil98 /Digital-Music-Store

Query a Digital Music Store Database, For this project, you will be assisting the Chinook team with understanding the media in their store, their customers and employees, and their invoice information.

khianvictorycalderon /sql-group-by

Basically compressing rows with aggregated functions (Equivalent to multiple COUNT())

ecdg /sql-review

Multiple SQL queries for reviewing purposes

MAHMOUD2ABDALLAH /Data-Analysis-SQL-Nanodegree-Udacity-Program

Learn how to execute core SQL commands to define, select, manipulate, control access, aggregate, and join data and data tables. Understand when and how to use subqueries, several window functions, and partitions to complete complex tasks. Clean data, optimize SQL queries and write select advanced JOINs to enhance analysis performance.

dkopinska /SQL

Two SQL-based data analysis projects, demonstrating skills in querying, aggregating, and transforming structured datasets. Projects include creating complex queries, joining multiple tables, filtering and grouping data, calculating key business metrics, and generating insights for decision-making.

MejlaP /when-was-the-golden-age-of-video-games

DataCamp project (SQL) - When Was the Golden Age of Video Games?

krauseannelize /project-sql-datacamp-basic

Collection of basic‑level SQL projects from DataCamp’s Real‑World Projects, applying query logic, filtering, joins, and aggregation to explore real‑world datasets and practice SQL fundamentals.

zahid-official /milestone-14-postgreSQL

🐘 PostgreSQL solutions exploring relational schema design, JOIN operations, aggregation functions, stored procedures, and data integrity constraints through practical wildlife conservation database problems.

Abhijeet107 /Task-6

Sales Trend Analysis Using Aggregations

sinhasomya100 /TASK-6

Sales Trend Analysis Using Aggregations

shubham-lingam /sql-practice-journey

A collection of SQL practice, problem-solving exercises, and completion achievements from SQL-Practice.com, W3Schools, HackerRank, DataLemur, and LeetCode.

RIOKOWI /pzn-belajar-laravel-database

Comprehensive Laravel Database Engineering fundamentals covering SQL operations, database transactions, Query Builder, advanced filtering, joins, aggregations, raw queries, query optimization, pagination, cursor-based data retrieval, database migrations, and database seeding.