Normalizing a table with low integrity.

SELECT count(*) AS repcount, "Location Name" FROM mytable
 WHERE "Company Name" IS NULL
 GROUP BY "Location Name"
 ORDER BY repcount DESC
 LIMIT 5;

Source: By Joe Mako as answer to the question

This code snippet was collected from stackoverflow, and is licensed under CC BY-SA 3.0

code-tutorial.com