Page Comparison

...

Queries

Acquiring data on Median /Average LOS and Median/Average Charges

select a.* from entity_values as a, measure_groups_measures as b
where a.measure_id = b.measure_id
and a.entity_id = ######
and b.measure_group_id = 14914

Acquiring data on both Average LOS and Average ChargesMedian Length of Stay

select a.* from entity_values as a, measure_groups_measures as b
where a.measure_id = b.measure_id
and a.entity_id = ######
and b.measure_group_id in (145,146)= 15

Acquiring data on both Median LOS and Median Charges

select a.* from entity_values as a, measure_groups_measures as b
where a.measure_id = b.measure_id
and a.entity_id = ######
and b.measure_group_id in (14714,14815)