Health Data Queries

For People in their 50s, admitted into emergency, diagnosed with cancer, with blood type A or AB.

Aggregate SQL Query

Returning 12 Records.
Average age of the group is 53.5000.
The total of billing amounts charged for the group is 241584.57305258495.
the average bill for the patients in this group is 20132.047754382078.

Raw data

Name
 Age
 Gender
 Blood Type
 Billing Amount
 Medication Administered
 Test Results
AlaN lEe 57 Female AB- 1821.3479464287602 Penicillin Inconclusive
ALiShA muRpHy 54 Female A+ 2568.011966680983 Lipitor Abnormal
aMY HoWArd 55 Male A+ 22334.067788612083 Paracetamol Normal
andrEa jOHNSon 52 Male AB- 10034.72126466271 Paracetamol Abnormal
beThaNY MoOrE 55 Female A+ 10300.657311375919 Paracetamol Normal
cynthIa FRye 50 Male A+ 29083.34115979853 Aspirin Inconclusive
GlENN maSSeY 51 Male A- 25152.2938878587 Lipitor Abnormal
JeNNIfER leOn 58 Male A- 30627.20861675614 Lipitor Abnormal
KRyStal mENDoZA 51 Male A- 50332.93241120667 Aspirin Abnormal
nIcOlE saNtiaGo 51 Male AB- 20274.970820988518 Aspirin Abnormal
Steven ROBiNson 54 Male AB+ 24755.026431309223 Paracetamol Inconclusive
tiMOthY CoLemaN 54 Female AB+ 14299.993446906701 Lipitor Abnormal

Assertion: There are slightly more male than female in the population. Paracetamol and Lipitor were most likely prescripted under the conditions.