StrataScratch Daily SQL Challenge

Overview

This repository contains my daily SQL solutions to challenges from StrataScratch. The exercises cover a range of SQL topics, including data querying, filtering, aggregation, joins, window functions, and more. The goal is to improve SQL skills through real-world problem-solving.

Repository Structure

• solutions/ – Contains SQL query solutions categorized by difficulty level or topic.
• problems/ – Stores the problem statements for reference.
• notebooks/ – Jupyter Notebooks with explanations and breakdowns of SQL queries.
• README.md – This file, providing an overview of the repository.

Topics Covered

• Basic SQL queries (SELECT, WHERE, ORDER BY)
• Aggregations and Group By
• Joins and Subqueries
• Window Functions
• Common Table Expressions (CTEs)
• Data Cleaning and Transformation

How to Use

1. Clone the repository:

   git clone https://github.com/pleasestation/StrataScratch_Daily_SQL_Challenge.git

2. Navigate to the directory:

   cd StrataScratch_Daily_SQL_Challenge

3. Open SQL scripts in your preferred SQL environment.

Resources

• StrataScratch – Source of SQL challenges
• SQL Documentation – Official SQL documentation

Contributions

This is a personal learning project, but if you'd like to contribute or discuss solutions, feel free to open an issue or fork the repository.

License

This repository is for educational purposes only. Problems belong to StrataScratch, and solutions are my own implementations.