Show the location codes and the number of documents in each location.
create table document_locations (location_code varchar, PRIMARY KEY (location_code))
select location_code, count(*) from document_locations group by location_code