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