belsrc · January 12, 2016 15:07
diff --git a/letter_count.sql b/letter_count.sql
 -- Get a count of, lets say, people's names that start with each letter
 -- from a specific city and state

 SELECT LEFT(name, 1) AS letter, COUNT(id) AS total 
 FROM data_table 
 WHERE city = ? AND state = ?
 GROUP BY letter 
 ORDER BY letter ASC;
	-- Get a count of, lets say, people's names that start with each letter
	-- from a specific city and state

	SELECT LEFT(name, 1) AS letter, COUNT(id) AS total
	FROM data_table
	WHERE city = ? AND state = ?
	GROUP BY letter
	ORDER BY letter ASC;