Insurance Dataset SQL Project

Dataset Overview

Project Introduction

This project explores an insurance dataset that includes demographic and health‑related data such as age, gender, BMI (body mass index), blood pressure, smoking habits, and more. Using SQL to analyze the dataset provides valuable insights into how various factors affect insurance claims.

Project Objectives

1. Analyze insurance claim data and demographic patterns.
2. Provide insights into risk factors influencing insurance claims, such as health status and smoking.
3. Assist beginners, intermediate, and advanced learners in practicing SQL skills with real‑world data.

Column Descriptions

• PatientID: Unique identifier for each patient.
• Age: Patient's age.
• Gender: Patient's gender (Male/Female).
• BMI: Patient's body mass index.
• BloodPressure: Patient's blood pressure.
• Diabetic: Whether the patient has diabetes (Yes/No).
• Children: Number of children the patient has.
• Smoker: Whether the patient smokes (Yes/No).
• Region: Geographic region where the patient resides.
• Claim: Insurance claim amount.

SQL Query Examples

Beginner Level Questions

1. Select all columns: Retrieve all columns from the dataset.
2. Distinct regions: Retrieve a list of distinct regions.
3. Total number of patients: Find the total number of patients.
4. Total number of smokers: Get the total number of smokers.
5. Diabetic patients: Retrieve patient IDs and claims for diabetic patients.
6. Total number of children: Compute the total number of children across all patients.
7. Male patients: Find all male patients.
8. Patients with BMI > 25: Select all columns for patients whose BMI is greater than 25.
9. Average age: Get the average age of all patients.
10. Patients from Southwest region: Find the total number of patients from the Southwest region.

Intermediate Level Questions

1. Total insurance claim for smokers: Compute the total insurance claim amount for smokers.
2. Average blood pressure for diabetic patients: Retrieve the average blood pressure for diabetic patients.
3. Female patients with more than two children: Find the total number of female patients who have more than two children.
4. Highest claim amount: Retrieve the highest claim amount among all patients.
5. Patients over 40 years old, BMI > 30, and smokers: List patients over 40 years old, with BMI greater than 30, who also smoke.
6. Number of patients per region: Retrieve the patient count for each region.
7. Minimum claim amount for non‑diabetic patients: Find the minimum claim amount among non‑diabetic patients.
8. Total claim amount for Northeast region: Compute the total insurance claim amount for patients from the Northeast region.
9. Patients with claim > 10,000 and more than two children: List all patients whose claim exceeds 10,000 and who have more than two children.
10. Diabetic patients per region: Retrieve the count of diabetic patients for each region.

Advanced Level Questions

1. Total insurance claim grouped by gender and smoking status: Compute the total insurance claim amount for patients grouped by gender and smoking status.
2. Top three regions where smokers have the highest average claim: Identify the three regions where smokers have the highest average claim amount.
3. Diabetic patients over 50 years old with blood pressure above average: Identify diabetic patients over 50 years old whose blood pressure is above the overall average.
4. Top five patients with highest claims: Find the five patients with the highest claim amounts.
5. Percentage of smokers per region: Calculate the percentage of smokers in each region.
6. Average claim for patients with at least two children, grouped by region: Retrieve the average claim for patients with at least two children, grouped by region.
7. Average claim for diabetic patients grouped by smoking status and region: Compute the average claim amount for diabetic patients, grouped by smoking status and region.
8. Top five claimants per region: List the top five patients with the highest claim amounts in each region.
9. Claim variance per region: Calculate the variance of insurance claim amounts for each region.
10. Highest claim amount for smokers over 50 years old per region: Identify the highest claim amount for smokers over 50 years old in each region.

CampusX Questions

1. Male patients from Southwest region: Display records of male patients from the Southwest region.
2. Patients with BMI between 30 and 45: Show all patient records with BMI in the range 30‑45.
3. Minimum and maximum blood pressure for smoking diabetic patients: Show the minimum and maximum blood pressure for smoking diabetic patients, with column names MinBP and MaxBP.
4. Unique patient count outside Southwest region: Find the number of unique patients outside the Southwest region.
5. Total claim amount for male smokers: Compute the total claim amount for male smokers.
6. All records from Southern region: Select all patient records from the Southern region.
7. Patients with normal blood pressure (90‑120): Find the number of patients whose blood pressure falls within the normal range (90‑120).
8. Patients under 17 with normal blood pressure: Find the number of patients under 17 years old whose blood pressure is within the normal range.
9. Average claim for non‑smoking diabetic females: Compute the average claim amount for non‑smoking diabetic female patients.
10. Update claim for PatientID 1234 to 5000: Set the claim amount to 5000 for the patient whose PatientID is 1234.
11. Delete records of smokers without children: Remove all smoker records where the patient has no children.