1 2 3 4 5 6 7 8 9 10 11 12 13
| SELECT DATE_FORMAT(datesampls, '%M') AS monthsampls,
COUNT(IF(StnCode='BM',SampleId,NULL)) AS BM,
COUNT(IF(StnCode='CHB',SampleId,NULL)) AS CHB,
COUNT(IF(StnCode='Cilerne',SampleId,NULL)) AS Cilerne
COUNT(IF(StnCode='EKALF',SampleId,NULL)) AS EKALF
COUNT(IF(StnCode='EPCU3',SampleId,NULL)) AS EPCU3
COUNT(IF(StnCode='ETATI1F',SampleId,NULL)) AS ETATI1F
COUNT(IF(StnCode='ETATI2F',SampleId,NULL)) AS ETATI2F
COUNT(IF(StnCode='EUB2',SampleId,NULL)) AS EUB2
FROM eqsampls
INNER JOIN eqstns ON eqstns.StnId = eqsampls.StnId
WHERE datesampls BETWEEN '2008-01-01' AND '2008-12-31'
GROUP BY MONTH(datesampls), StnCode |
Partager