3198. Find Cities in Each State

SQL

SELECT
  state,
  GROUP_CONCAT(city ORDER BY city SEPARATOR ', ') AS cities
FROM Cities
GROUP BY 1
ORDER BY 1;