This repository contains SQL queries from various popular online learning resources e.g. Vertabelo Academy, SQLZoo etc.
Spark in Action, 2nd edition - chapter 15 - Aggregating your data
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.
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.
Basically compressing rows with aggregated functions (Equivalent to multiple COUNT())
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.
DataCamp project (SQL) - When Was the Golden Age of Video Games?
🐘 PostgreSQL solutions exploring relational schema design, JOIN operations, aggregation functions, stored procedures, and data integrity constraints through practical wildlife conservation database problems.
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.
Sales Trend Analysis Using Aggregations
Sales Trend Analysis Using Aggregations
A collection of SQL practice, problem-solving exercises, and completion achievements from SQL-Practice.com, W3Schools, HackerRank, DataLemur, and LeetCode.
To associate your repository with the sql-aggregation topic, visit your repo's landing page and select "manage topics."