# thomas-george-t/hackerrank-sql-challenges-solutions architecture

> Architecture diagram of the GitHub repository thomas-george-t/hackerrank-sql-challenges-solutions, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2025-05-26). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/thomas-george-t/hackerrank-sql-challenges-solutions
- Repository: https://github.com/thomas-george-t/hackerrank-sql-challenges-solutions

## Overview

##### Project type and purpose
- This is not a service or runtime application but a documentation/solutions repository. It contains categorized SQL scripts that solve HackerRank challenges in a MySQL environment. Its “architecture” is purely organizational: it groups .sql files into domains, provides a README, and includes references.

##### File structure
- Top-level files:
- README.md – overview and instructions
- LICENSE.md – project license
- .gitattributes – Git configuration
- Top-level directories (each domain of SQL challenges):
- Basic Select
- Advanced Select
- Aggregation
- Basic Join
- ADVANCE JOIN
- Each directory holds dozens of .sql scripts named after individual HackerRank problems. There are no executables, services, or other code.

##### README for additional insights
- Confirms that all scripts run in MySQL.
- Lists external links (HackerRank challenge pages) as the origin of each file.
- Mentions references (SQL formatter, StackOverflow answers).

##### Elements
- Clear labels: e.g., “Domain: Basic Select,” “MySQL Environment.”
- From Repository → Domain folders
- From Domain folders → Script sets
- From Scripts → MySQL Environment (execution)
- From Scripts → HackerRank (origin links)
- File sets in another
- Docs in a third style

## Diagram (Mermaid)

```mermaid
flowchart TB
    %% Repository
    subgraph "Repository" 
        direction TB
        RepoDocs["README.md & LICENSE.md"]:::docs
        GitConfig[".gitattributes"]:::config
        subgraph "Domains"
            direction TB
            subgraph "Basic Select" 
                direction TB
                BS1["Select-All.sql"]:::script
                BS2["Weather-Observation-Station-1.sql"]:::script
            end
            subgraph "Advanced Select"
                direction TB
                AS1["Binary Tree Nodes.sql"]:::script
                AS2["Type of Triangle.sql"]:::script
            end
            subgraph "Aggregation"
                direction TB
                AG1["Top Earners.sql"]:::script
                AG2["Weather Observation Station 13.sql"]:::script
            end
            subgraph "Basic Join"
                direction TB
                BJ1["African Cities.sql"]:::script
                BJ2["Contest Leaderboard.sql"]:::script
            end
            subgraph "ADVANCE JOIN"
                direction TB
                AJ1["Placements.sql"]:::script
                AJ2["SQL PROJECT PLANNING.sql"]:::script
            end
        end
    end

    %% External Systems
    HR["HackerRank Challenge Platform"]:::external
    MYSQL["MySQL Environment"]:::db

    %% Connections
    RepoDocs -->|"includes"| RepoDocs
    GitConfig -->|"configures repo"| RepoDocs
    subgraph ExecutionFlow
        direction LR
        Domains -->|"execute .sql"| MYSQL
        Domains -->|"origin challenge"| HR
    end

    %% Click Events
    click RepoDocs "https://github.com/thomas-george-t/hackerrank-sql-challenges-solutions/blob/master//README.md"
    click RepoDocs "https://github.com/thomas-george-t/hackerrank-sql-challenges-solutions/blob/master//LICENSE.md"
    click GitConfig "https://github.com/thomas-george-t/hackerrank-sql-challenges-solutions/blob/master//.gitattributes"
    click BS1 "https://github.com/thomas-george-t/hackerrank-sql-challenges-solutions/blob/master//Basic Select/Select-All.sql"
    click BS2 "https://github.com/thomas-george-t/hackerrank-sql-challenges-solutions/blob/master//Basic Select/Weather-Observation-Station-1.sql"
    click AS1 "https://github.com/thomas-george-t/hackerrank-sql-challenges-solutions/blob/master//Advanced Select/Binary Tree Nodes.sql"
    click AS2 "https://github.com/thomas-george-t/hackerrank-sql-challenges-solutions/blob/master//Advanced Select/Type of Triangle.sql"
    click AG1 "https://github.com/thomas-george-t/hackerrank-sql-challenges-solutions/blob/master//Aggregation/Top Earners.sql"
    click AG2 "https://github.com/thomas-george-t/hackerrank-sql-challenges-solutions/blob/master//Aggregation/Weather Observation Station 13.sql"
    click BJ1 "https://github.com/thomas-george-t/hackerrank-sql-challenges-solutions/blob/master//Basic Join/African Cities.sql"
    click BJ2 "https://github.com/thomas-george-t/hackerrank-sql-challenges-solutions/blob/master//Basic Join/Contest Leaderboard.sql"
    click AJ1 "https://github.com/thomas-george-t/hackerrank-sql-challenges-solutions/blob/master//ADVANCE JOIN/Placements.sql"
    click AJ2 "https://github.com/thomas-george-t/hackerrank-sql-challenges-solutions/blob/master//ADVANCE JOIN/SQL PROJECT PLANNING.sql"

    %% Styles
    classDef docs fill:#FFC069,stroke:#333,stroke-width:1px
    classDef config fill:#FFD591,stroke:#333,stroke-width:1px
    classDef script fill:#E6FFFB,stroke:#333,stroke-width:1px
    classDef external fill:#D3ADF7,stroke:#333,stroke-width:1px
    classDef db fill:#B3E5FC,stroke:#333,stroke-width:1px
    classDef folder fill:#FFF1B8,stroke:#333,stroke-width:1px
```
