Available Tables:

• healthcare_dataset
• hr_by_age_gender
• human_vital_signs_dataset_2024

Debug: Column Names in healthcare_dataset

• Name
• Age
• Gender
• BloodType
• MedicalCondition
• DateofAdmission
• Doctor
• Hospital
• InsuranceProvider
• BillingAmount
• RoomNumber
• AdmissionType
• DischargeDate
• Medication
• TestResults

DEBUG SQL Summary:


    SELECT 
        COUNT(*) AS total_patients,
        AVG(Age) AS avg_age,
        SUM(Billing_Amount) AS total_billing,
        AVG(Billing_Amount) AS avg_billing
    FROM healthcare_dataset
    WHERE 
    Gender = 'F'
    AND Age BETWEEN 50 AND 60
    AND AdmitType = 'Emergency'
    AND Medication = 'Lipitor'
    AND TestResult = 'Inconclusive'