SQLGuru

Welcome to SQLGuru! This project contains SQL questions along with their solutions, covering various topics and complexities to help you master SQL.

Project Structure

The project is organized into directories, each representing a different SQL topic or question. Each directory contains:

• question.txt: The question description.
• solution.sql: The SQL solution for the question.

Usage

To explore a specific question and its solution:

• Export the database.sqlite file using suitable tool or drop file at SQLite Viewer.

• Run npm install for installing required modules.

• Navigate to the corresponding directory.

• Open question.md to read the question description.

• Open solution.sql to view the solution.

Example Structure

SQLGuru/
│
├── 01_Filtering_Patients_by_Weight_Range/
│   ├── question.md
│   └── solution.sql
│
├── 02_Finding_Patients_from_Hamilton_with_Allergies/
│   ├── question.md
│   └── solution.sql
|
├── ...
|
└── database.sqlite

Topics Covered

1. Filtering Data

Contributing

If you would like to contribute to SQLGuru, follow these steps:

1. Fork the repository.
2. Create a new branch for your feature or bugfix.
3. Commit your changes.
4. Push your changes to your fork.
5. Create a pull request.