Task: Text to Code
Input (English): find each value of Location_Code in Ref_Locations table along with the number of the corresponding rows to each value
Output (English): SELECT Location_Code , Count ( * ) FROM Ref_Locations GROUP BY Location_Code