Skip to content

README.md

Latest commit

 

History

History
44 lines (31 loc) · 1.53 KB

README.md

File metadata and controls

44 lines (31 loc) · 1.53 KB

CSI-Assignment1

💼 Celebal Technologies Internship – Level A SQL Assignment

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.

📌 Project Overview

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

🛠️ Technologies & Tools Used

  • 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.

🗂️ Repository Structure

📁 SQL Queries/
├── Q01_solution.sql
├── Q02_solution.sql
├── ...
├── Q42_solution.sql
📁 Output/
├── Q01.csv
├── Q02.csv
├── ...
├── Q42.csv
└── README.md