COUNT province by regione

[sal21]

paraphs i'm stupid...

based the 20 REGIONI how to count PROVINCE for each REGIONI?

for example for REGIONE=CAMPANIA have five distinct PROVINCE

to the and of query:

CAMPANIA 5
LAZIO 5

[HansV]

Like this:

SELECT REGIONE, COUNT(PROVINCIA) AS CONTADIPROVINCIA FROM (SELECT DISTINCT REGIONE, PROVINCIA FROM [www-zip-codes-maps-com]) GROUP BY REGIONE

[sal21]

Like this:

SELECT REGIONE, COUNT(PROVINCIA) AS CONTADIPROVINCIA FROM (SELECT DISTINCT REGIONE, PROVINCIA FROM [www-zip-codes-maps-com]) GROUP BY REGIONE

Perfect!