Task: Text to Code
Input (English): Step 1: find the number of rows of each value of City in city table.
Step 2: find City, Regional_Population in city table whose corresponding value in step 1 is greater than 1
Output (English): SELECT City , Regional_Population FROM city GROUP BY City HAVING Count ( * ) > 1