List all the catalog ids and their respective catalog publisher?
select catalog_id, catalog_publisher from catalogs
How many catalogs have each publisher published?
select catalog_publisher, count(*) from catalogs group by catalog_publisher
Which publisher has the least?
select catalog_publisher from catalogs group by catalog_publisher order by count(*) asc limit 1
How about the most?
select catalog_publisher from catalogs group by catalog_publisher order by count(*) desc limit 1