12 ORL
11 VENINCE
10 BEIJING
8 LHR

SELECT month, city , count(*) AS 'no of people visiting'
FROM table
GROUP BY month, city