belsrc · January 12, 2016 15:09
diff --git a/distinct_count.sql b/distinct_count.sql
 -- Get a count of people in each city from a specific state

 SELECT DISTINCT(city) AS city, COUNT(city) AS total 
 FROM data
 WHERE state = ?
 GROUP BY city
 ORDER BY city ASC;
	-- Get a count of people in each city from a specific state

	SELECT DISTINCT(city) AS city, COUNT(city) AS total
	FROM data
	WHERE state = ?
	GROUP BY city
	ORDER BY city ASC;