Various ETL issues: StandardizedClinicalDataTables/MEASUREMENT/check_etl.sql

[MattMuffin]

There seems to be an extra "AS" near line 67, that needs to be removed.

SELECT org_name::TEXT, count(1) FROM ( SELECT DISTINCT ON (hadm_id, spec_type_desc, org_name, coalesce(charttime, chartdate)) AS org_name FROM microbiologyevents WHERE org_name IS NOT NULL ) tmp GROUP BY org_name ORDER BY 2, 1 desc;

Should be:

SELECT org_name::TEXT, count(1) FROM ( SELECT DISTINCT ON (hadm_id, spec_type_desc, org_name, coalesce(charttime, chartdate)) org_name FROM microbiologyevents WHERE org_name IS NOT NULL ) tmp GROUP BY org_name ORDER BY 2, 1 desc;