This has probably been asked before, but I'm unable to make my way through the myriad of search results.
Given a non-normalized MySQL table, what is the most optimized query to count the number of times each distinct value of column x was used?
e.g. Given a table containing
SELECT count(email) as c FROM orders GROUP BY email