🏥 Hospital Patient Data Analysis (SQL Project)

📌 Overview

This project analyzes hospital patient records using SQL to find insights related to patient demographics, treatment cost, hospital stay, and satisfaction.

📊 Dataset

Single CSV file containing: Patient_ID, Age, Gender, patient_condition, condition_procedure, Cost, Length_of_Stay, Readmission, Outcome, Satisfaction

🛠️ Tools Used

• MySQL Workbench
• SQL
• Kaggle

📈 Analysis Performed

• Total patients count
• Gender distribution
• Age group analysis
• Cost analysis
• Average hospital stay
• Readmission rate
• Top Most Expensive Procedures Per Condition
• Patient Satisfaction vs Cost Relationship

📁 Project Structure

• data/ → CSV dataset
• SQL/ → Table creation & loading scripts
• analysis_queries/ → SQL analysis queries
• screenshots/ → Output results

🚀 How to Run

• Create database in MySQL
• Run SQL/create_tables.sql
• Run SQL/insert_data.sql
• Execute analysis_queries files

🚀 Conclusion

This project helped me practice SQL concepts like JOIN, GROUP BY, HAVING, and window functions.

👩‍💻 Author

Tapati Paul