Can you also tell me how many documents are there for that location? | Do you mean the number of documents in the location with code x? | Yes, please.
SELECT count ( * )  from document_locations where Location_Code  =  'x'
number of documents in the location with code x refers to counting all rows where Location_Code = 'x';