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

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.

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.

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

Sales Trend Analysis Using Aggregations

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.

Multiple SQL queries for reviewing purposes

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.

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.

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