danabauer · May 21, 2013 14:01
diff --git a/gistfile1.sql b/gistfile1.sql
 # This is counting distinct facilities with a capacity less than 10, grouped by star level

 SELECT star_level, count(DISTINCT facility_name) FROM ocdelphl
 where capacity < 10
 group by star_level
	# This is counting distinct facilities with a capacity less than 10, grouped by star level

	SELECT star_level, count(DISTINCT facility_name) FROM ocdelphl
	where capacity < 10
	group by star_level