SELECT COUNT(id)
FROM stats
WHERE record_date.YEAR = 2009
GROUP BY record_date.YEAR

SELECT COUNT(id)
FROM stats
GROUP BY record_date.YEAR, record_date.MONTH

Answer:

GROUP BY YEAR(record_date), MONTH(record_date)

id (1) tag ('night')
id (2) tag ('awesome')
id (3) tag ('night')

SELECT COUNT(*), `Tag` from `images-tags`
GROUP BY `Tag`

SELECT COUNT(id), `Tag` from `images-tags`
GROUP BY `Tag`
ORDER BY COUNT(id) DESC
LIMIT 20

Answer :

SELECT COUNT(id) AS theCount, `Tag` from `images-tags`
GROUP BY `Tag`
ORDER BY theCount DESC
LIMIT 20