A structured, mentor-driven environment to master SQL query writing through iterative challenges.
This repository documents my journey in mastering SQL through a customized "AI Mentor" framework. By using ChatGPT as a query coach, I solve increasingly complex challenges that simulate real-world data engineering and analysis scenarios.
🎯 This repository showcases expertise in:
- SQL Development: Writing clean, efficient, and readable queries.
- Query Optimization: Refining logic for better performance.
- Analytical Thinking: Solving business problems with data-driven logic.
To leverage AI as a specialized SQL mentor that provides structured, incremental challenges and rigorous code reviews based on industry best practices.
- Foundational: SELECT, WHERE, ORDER BY, LIMIT
- Aggregations: COUNT, SUM, AVG, MIN, MAX
- Logic & Groups: GROUP BY, HAVING, CASE WHEN
- Relational: INNER JOIN, LEFT JOIN, NULL handling
- Advanced: Simple Subqueries
- Incremental Difficulty: Start simple and scale up based on performance.
- Detailed Schema: Every challenge must include table names, types, and expected outputs.
- Strict Evaluation: Queries are reviewed for logic, readability, efficiency, and edge cases.
- Rubric-Based Scoring: Every submission receives a score out of 10 with feedback.
Everything used in this project is for Free!
- ChatGPT: Used as the SQL Mentor and Challenge Generator.
- SQLLite Online: A web-based environment to test queries without local setup.
- DB Fiddle: Useful for sharing schema and test cases.
| Challenge # | Topic | Status | Score |
|---|---|---|---|
| 01 | Basic Aggregations | ✅ Completed | 9/10 |
| 02 | Multi-table Joins | 🏗️ In Progress | -- |
| 03 | Subqueries & CTEs | 🔒 Locked | -- |