Young adults.
A substantial billing total.

Exploring recorded hospital charges for men under 40 with obesity and abnormal test results.

Gender: MaleAge: Under 40Condition: ObesityTest results: Abnormal

Matching records

Full filtered group

Average age

28.2

Years

Total billing

$742,899.89

Recorded charges

Average bill

$25,617.24

Per matching record

The data insight

The 29 matching records have an average age of 28.2 years and total recorded charges of $742,899.89, averaging $25,617.24 per record. This illustrates the billing total within this specific group of younger adults.

Behind the numbers

Matching records, ordered by age and then name.

29 of 29 records

Patient details for the filtered group
Patient name	Age	Blood type	Admission	Admitted on	Medication	Test results	Billing amount
leah FRederICk	19	O-	Emergency	2023-02-03	Lipitor	Abnormal	$25,856.22
MaTThEW bELl	19	O+	Urgent	2021-02-04	Aspirin	Abnormal	$20,086.22
TImothY ELLIoTT	19	AB-	Urgent	2019-08-03	Ibuprofen	Abnormal	$30,789.01
meLiSSA LawRENcE	20	O+	Emergency	2023-07-09	Lipitor	Abnormal	$35,205.28
dAVid pAyne	22	A+	Emergency	2020-07-08	Ibuprofen	Abnormal	$46,772.58
JOYCE MoOdY	22	AB-	Elective	2022-04-03	Paracetamol	Abnormal	$7,732.67
beNJAmIN HerrErA	23	AB+	Urgent	2019-07-12	Aspirin	Abnormal	$22,022.02
KatHryn SMiTH	23	B-	Urgent	2020-01-05	Lipitor	Abnormal	$11,418.62
kATHY WalLer	23	O-	Emergency	2020-10-30	Ibuprofen	Abnormal	$42,345.64
oSCar nElSOn	24	AB+	Emergency	2023-06-27	Ibuprofen	Abnormal	$39,018.77
cyNTHiA willIams	25	A-	Urgent	2023-11-01	Lipitor	Abnormal	$20,161.44
JEnNiFEr COOpER	25	A+	Elective	2020-04-26	Aspirin	Abnormal	$49,934.14
KAREn johnsoN	25	O+	Emergency	2019-06-23	Aspirin	Abnormal	$43,400.67
KIMBErly vasqueZ	26	A-	Urgent	2023-10-23	Penicillin	Abnormal	$38,142.11
meLAnie mORalEs	26	B-	Urgent	2020-12-18	Ibuprofen	Abnormal	$39,979.24
JasmInE luNA	27	A-	Urgent	2020-04-10	Paracetamol	Abnormal	$11,023.29
brIaN SMiTh	28	B-	Elective	2022-05-31	Lipitor	Abnormal	$1,771.29
aNDrEW marTineZ	30	B-	Emergency	2023-05-17	Penicillin	Abnormal	$15,170.34
ChristophEr bROWN	30	B+	Urgent	2019-06-18	Lipitor	Abnormal	$20,070.14
anTHoNY PerKinS	31	O-	Urgent	2024-01-10	Lipitor	Abnormal	$28,483.88
JIlL TayLOR	32	O-	Urgent	2020-05-18	Aspirin	Abnormal	$5,614.52
SuMmer heRmAN	32	A-	Urgent	2023-08-09	Aspirin	Abnormal	$22,810.14
AusTIn AndERson	37	AB-	Urgent	2020-07-14	Lipitor	Abnormal	$28,367.19
DanIeLLe cANNOn	37	B+	Elective	2020-03-19	Aspirin	Abnormal	$6,709.76
CoURtney stepHeNs	38	B-	Emergency	2022-04-10	Paracetamol	Abnormal	$41,134.79
mRS. jamiE cAMPBELl	38	AB-	Urgent	2020-03-08	Paracetamol	Abnormal	$17,440.47
aNN MIlLEr	39	B+	Elective	2022-09-07	Aspirin	Abnormal	$11,904.52
BrIAn dOWNS	39	AB-	Elective	2022-07-07	Penicillin	Abnormal	$38,136.61
DusTIn cOX	39	AB+	Elective	2019-09-26	Lipitor	Abnormal	$21,398.34

Source: supplied healthdataset1.sql.txt · healthcare_dataset. Names retain the source spelling. Billing amounts represent recorded charges, not verified payments or out-of-pocket costs. These descriptive results do not establish causes or compare this group with other patients.

View the two SQL queries

1. Statistical summary

SELECT COUNT(*) AS patient_count, AVG(Age) AS average_age,
        SUM(BillingAmount) AS total_billing, AVG(BillingAmount) AS average_billing
        FROM healthcare_dataset WHERE Gender = 'Male' AND Age < 40 AND MedicalCondition = 'Obesity' AND TestResults = 'Abnormal'

2. Patient details

SELECT * FROM healthcare_dataset WHERE Gender = 'Male' AND Age < 40 AND MedicalCondition = 'Obesity' AND TestResults = 'Abnormal' ORDER BY Age ASC, Name ASC LIMIT 40

Both queries use the same four filters. The supplied dataset returns 29 matches, below both the 30-record restriction and the 40-row display maximum.