[SQL] COUNT e CAMPI

[kodode]

Ciao a tutti!

io vorrei ottenere in un'unica query il caunt dei record e per ogni record un particolare valore.. si può?!?
mi spiego meglio:

vorrei questo risultato
ADAfin -- NUMada
2008-08-30 -- 11
2009-08-30 -- 11
2009-02-16 -- 11
2008-03-06 -- 11
2009-02-09 -- 11
2008-08-30 -- 11
2008-05-10 -- 11
2008-08-10 -- 11
2009-02-09 -- 11
2008-03-13 -- 11
2008-08-30 -- 11


ho provato con:

SELECT ADA_1.ADAfin , COUNT( ADA.ADAidr ) AS NUMada 
FROM ADA LEFT JOIN ADA AS ADA_1 ON ADA.ADAidr = ADA_1.ADAidr 
WHERE 
( CURDATE() BETWEEN ADA.ADAini AND ADA.ADAfin AND ADA.ADAnii = 0 )OR ( ADA.ADAfin > CURDATE() AND ADA.ADAnii > 0 AND ADA.ADAnid > 0 )
GROUP BY ADA.ADAidr 

e con

SELECT ADAfin 
FROM ADA 
WHERE 
( CURDATE() BETWEEN ADAini AND ADAfin AND ADAnii = 0 )OR ( ADAfin > CURDATE() AND ADAnii > 0 AND ADAnid > 0 )
UNION ALL 
SELECT COUNT( ADAidr ) AS NUMada 
FROM ADA 
WHERE 
( CURDATE() BETWEEN ADAini AND ADAfin AND ADAnii = 0 )OR ( ADAfin > CURDATE() AND ADAnii > 0 AND ADAnid > 0 ) 

qualche aiuto? grazie...

[berto3]

Vediamo se ho capito, tu vorresti sapere quanti record sono presenti con un certa condizione.

SELECT ADA.ADAfin , COUNT(*) AS NUMada
FROM ADA
WHERE (CURDATE() BETWEEN ADA.ADAini AND ADA.ADAfin AND ADA.ADAnii = 0 )
OR ( ADA.ADAfin > CURDATE() AND ADA.ADAnii > 0 AND ADA.ADAnid > 0 )
GROUP BY ADA.ADAfin

...
Ciao