Problem with SQL Count(*)

Databases
1

Hi all.

I need your help, this is my table in db mysql:

N_T	COD_C		DENOMINAZIONE_C		COD_L	DATA
31437	001450		SALA			A	2010-05-31
41147	001450		SALA			F	2010-05-31
31245	003614		POD.RIVAZZA		A	2010-05-30
31261	041413		PORCARI PIN.		B	2010-05-29
31250	081040		CAMPANELLA		B	2010-05-29
31305	081040		CAMPANELLA		B	2010-05-28
31368	002977		LA TORRE		E	2010-05-28
30342	005405		LIDO			A	2010-05-28

I need see and the count the rows with data between 2010-05-25 and 2010-06-07 when count > 1.

I try this query but I see all rows…


SELECT COUNT(*) AS Number 
   FROM dotable
      WHERE 1 AND DATA BETWEEN '2010-05-25' AND '2010-06-07' 
   GROUP BY 
      COD_C, DENOMINAZIONE_C, COD_L

I need this output:

COD_C	Number
001450	2	
081040	2

Any help would be very much appreciated and many thanks to any who can help me.

Thanks in advance.
Chevy

2 
SELECT cod_c
     , COUNT(*) AS Number 
  FROM dotable
 WHERE data BETWEEN '2010-05-25' AND '2010-06-07' 
GROUP 
    BY cod_c
HAVING COUNT(*) > 1
3

thanks!