# santoshkhatri9860/advanced-sql-practice-mysql architecture

> Architecture diagram of the GitHub repository santoshkhatri9860/advanced-sql-practice-mysql, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-20). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/santoshkhatri9860/advanced-sql-practice-mysql
- Repository: https://github.com/santoshkhatri9860/advanced-sql-practice-mysql

## Overview

Advanced SQL Practice is a prompts-first workbook for SQL learners: choose a topic, attempt its exercises, then consult separate solutions. Its documented coverage spans subqueries, window functions, CTEs, and date/time patterns. An optional local MySQL setup supports practice with sample data. The README documents the overall workflow and capabilities; no source excerpts were provided, so file-level calls or mappings between individual prompts and solutions cannot be verified.

Main entry points: [`db/init/01_setup_advanced_sql_practice.sql`](https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/db/init/01_setup_advanced_sql_practice.sql) (Database setup), [`docker-compose.yml`](https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/docker-compose.yml) (Optional Docker setup), [`exercises/01_subqueries/01_subqueries.sql`](https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/exercises/01_subqueries/01_subqueries.sql) (Subqueries, EXISTS), [`exercises/02_exists_correlated/02_exists_correlated.sql`](https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/exercises/02_exists_correlated/02_exists_correlated.sql) (Correlated EXISTS)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_practice["Practice prompts"]
  node_subqueries["Subqueries, EXISTS<br/>[01_subqueries.sql]"]
  node_correlated["Correlated EXISTS"]
  node_windows["Window functions"]
  node_frames["Window frames"]
  node_laglead["LAG and LEAD<br/>[05_lag_lead.sql]"]
  node_rownumber["ROW_NUMBER<br/>[06_row_number.sql]"]
  node_ranking["Rank functions"]
  node_cte["CTEs"]
  node_multi_cte["Multi-CTE<br/>[09_cte_multi.sql]"]
  node_recursive_numbers["Recursive numbers"]
  node_hierarchy["Recursive hierarchy"]
  node_datetime["Date and time<br/>[12_datetime.sql]"]
end

subgraph group_answers["Reference solutions"]
  node_solution_set["Solution collection"]
end

subgraph group_setup["Local database"]
  node_db_setup["Database setup"]
  node_compose["Optional Docker setup<br/>[docker-compose.yml]"]
end

node_learner(("Learner"))
node_mysql[("MySQL")]

node_learner -->|"practices"| node_subqueries
node_learner -->|"practices"| node_correlated
node_learner -->|"practices"| node_windows
node_learner -->|"practices"| node_frames
node_learner -->|"practices"| node_laglead
node_learner -->|"practices"| node_rownumber
node_learner -->|"practices"| node_ranking
node_learner -->|"practices"| node_cte
node_learner -->|"practices"| node_multi_cte
node_learner -->|"practices"| node_recursive_numbers
node_learner -->|"practices"| node_hierarchy
node_learner -->|"practices"| node_datetime
node_learner -->|"checks work"| node_solution_set
node_db_setup -->|"sets up"| node_mysql
node_compose -.->|"optionally starts"| node_mysql

click node_subqueries "https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/exercises/01_subqueries/01_subqueries.sql"
click node_correlated "https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/exercises/02_exists_correlated/02_exists_correlated.sql"
click node_windows "https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/exercises/03_window_basics/03_window_basics.sql"
click node_frames "https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/exercises/04_window_frames/04_window_frames.sql"
click node_laglead "https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/exercises/05_lag_lead/05_lag_lead.sql"
click node_rownumber "https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/exercises/06_row_number/06_row_number.sql"
click node_ranking "https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/exercises/07_rank_dense_rank/07_rank_dense_rank.sql"
click node_cte "https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/exercises/08_cte_non_recursive/08_cte_non_recursive.sql"
click node_multi_cte "https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/exercises/09_cte_multi/09_cte_multi.sql"
click node_recursive_numbers "https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/exercises/10_recursive_cte_numbers/10_recursive_cte_numbers.sql"
click node_hierarchy "https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/exercises/11_recursive_cte_hierarchy/11_recursive_cte_hierarchy.sql"
click node_datetime "https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/exercises/12_datetime/12_datetime.sql"
click node_solution_set "https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/tree/main/solutions"
click node_db_setup "https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/db/init/01_setup_advanced_sql_practice.sql"
click node_compose "https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/docker-compose.yml"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_subqueries,node_correlated,node_windows,node_frames,node_laglead,node_rownumber,node_ranking,node_cte,node_multi_cte,node_recursive_numbers,node_hierarchy,node_datetime toneBlue
class node_solution_set,node_mysql toneAmber
class node_db_setup,node_compose toneMint
class node_learner toneIndigo
```

## Components

### Practice prompts

- [Subqueries, EXISTS](https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/exercises/01_subqueries/01_subqueries.sql): `exercises/01_subqueries/01_subqueries.sql`
- [Correlated EXISTS](https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/exercises/02_exists_correlated/02_exists_correlated.sql): `exercises/02_exists_correlated/02_exists_correlated.sql`
- [Window functions](https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/exercises/03_window_basics/03_window_basics.sql): `exercises/03_window_basics/03_window_basics.sql`
- [Window frames](https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/exercises/04_window_frames/04_window_frames.sql): `exercises/04_window_frames/04_window_frames.sql`
- [LAG and LEAD](https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/exercises/05_lag_lead/05_lag_lead.sql): `exercises/05_lag_lead/05_lag_lead.sql`
- [ROW_NUMBER](https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/exercises/06_row_number/06_row_number.sql): `exercises/06_row_number/06_row_number.sql`
- [Rank functions](https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/exercises/07_rank_dense_rank/07_rank_dense_rank.sql): `exercises/07_rank_dense_rank/07_rank_dense_rank.sql`
- [CTEs](https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/exercises/08_cte_non_recursive/08_cte_non_recursive.sql): `exercises/08_cte_non_recursive/08_cte_non_recursive.sql`
- [Multi-CTE](https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/exercises/09_cte_multi/09_cte_multi.sql): `exercises/09_cte_multi/09_cte_multi.sql`
- [Recursive numbers](https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/exercises/10_recursive_cte_numbers/10_recursive_cte_numbers.sql): `exercises/10_recursive_cte_numbers/10_recursive_cte_numbers.sql`
- [Recursive hierarchy](https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/exercises/11_recursive_cte_hierarchy/11_recursive_cte_hierarchy.sql): `exercises/11_recursive_cte_hierarchy/11_recursive_cte_hierarchy.sql`
- [Date and time](https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/exercises/12_datetime/12_datetime.sql): `exercises/12_datetime/12_datetime.sql`

### Reference solutions

- [Solution collection](https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/tree/main/solutions): `solutions`

### Local database

- [Database setup](https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/db/init/01_setup_advanced_sql_practice.sql): `db/init/01_setup_advanced_sql_practice.sql`
- [Optional Docker setup](https://github.com/santoshkhatri9860/advanced-sql-practice-mysql/blob/main/docker-compose.yml): `docker-compose.yml`

### Other components

- **Learner**
- **MySQL**

## Connections

- Learner → Subqueries, EXISTS: practices (evidence: `README.md`)
- Learner → Correlated EXISTS: practices (evidence: `README.md`)
- Learner → Window functions: practices (evidence: `README.md`)
- Learner → Window frames: practices (evidence: `README.md`)
- Learner → LAG and LEAD: practices (evidence: `README.md`)
- Learner → ROW_NUMBER: practices (evidence: `README.md`)
- Learner → Rank functions: practices (evidence: `README.md`)
- Learner → CTEs: practices (evidence: `README.md`)
- Learner → Multi-CTE: practices (evidence: `README.md`)
- Learner → Recursive numbers: practices (evidence: `README.md`)
- Learner → Recursive hierarchy: practices (evidence: `README.md`)
- Learner → Date and time: practices (evidence: `README.md`)
- Learner → Solution collection: checks work (evidence: `README.md`)
- Database setup → MySQL: sets up (evidence: `README.md`)
- Optional Docker setup → MySQL: optionally starts (evidence: `README.md`)
