sql-assignments

30 Days SQL Micro Course – Hospital Data Assignment

This repository contains my completed assignment for the 30 Days SQL Micro Course.
The project uses the provided Hospital Data CSV file to solve real-world SQL queries focused on data analysis, reporting, and database understanding.

---

Assignment Tasks

The assignment includes the following SQL requirements:

1. Total number of patients
2. Average number of doctors per hospital
3. Top 3 departments with the highest patient count
4. Hospital with the maximum medical expenses
5. Daily average medical expenses
6. Longest hospital stay (difference between admission & discharge dates)
7. Total patients treated per city
8. Average length of stay per department
9. Department with the lowest number of patients
10. Monthly medical expenses summary (grouped by month)

A minimum of 6 correct solutions is required to qualify for the certificate.

---

Included Files

• Hospital Data.csv – Dataset provided in the course
• assignment_queries.sql – SQL queries written to solve the assignment
• Assignment_Output.pdf – Final report submitted for certificate review

---

Skills Demonstrated

• SQL Aggregations
• Group By operations
• Date and time functions
• Ranking / Top-N queries
• Real-world data analysis
• Report creation and summarization

---

Course Support

For official course assistance:
[email protected]
Website: www.skillcourse.in