Basic Data Profiling

As a DBA I am very often asked to give profiling information from the database. This result need to be understandable by non technical persons.

The basic query

SELECT count(*) as Nb, the_field as PrettyName
FROM the_table
GROUP BY the_field