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
Sales Trend Analysis Using Aggregations
DataCamp project (SQL) - When Was the Golden Age of Video Games?
Sales Trend Analysis Using Aggregations
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.
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.
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.
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.
Add a description, image, and links to the sql-aggregation topic page so that developers can more easily learn about it.
To associate your repository with the sql-aggregation topic, visit your repo's landing page and select "manage topics."