This repository contains the complete solution to the Level A SQL Task, assigned as part of the Week 1 deliverables during the Summer Internship Program at Celebal Technologies.
All 42 queries were developed using the AdventureWorks2022 OLTP database and tested within SQL Server Management Studio (SSMS). The goal of the task was to assess practical SQL skills and business data interpretation based on realistic enterprise datasets.
This assignment involved solving 42 SQL-based problems simulating real-world business scenarios. The problems ranged across various categories including:
- Customer and product queries
- Hierarchical employee relationships
- Aggregate sales and revenue analytics
- Data filtering, joining, grouping, and summarization
- Region and country-based order summaries
- SQL Server 2022 Express / Developer Edition
- SQL Server Management Studio (SSMS)
- AdventureWorks2022 OLTP Sample Database
✔️ All queries are designed and tested using the default schema structure of the AdventureWorks2022 database available from Microsoft's official GitHub repository.
📁 SQL Queries/
├── Q01_solution.sql
├── Q02_solution.sql
├── ...
├── Q42_solution.sql
📁 Output/
├── Q01.csv
├── Q02.csv
├── ...
├── Q42.csv
└── README.md