MYSQL ORDER date BY RANGE

[badaze]

Prova cosi :

select anno2, sum(tot)
(
SELECT CONCAT((FLOOR(`anno`/10))*10,'-',((FLOOR(`anno`/10))*10)+9) `anno2`, COUNT(*) tot FROM opere GROUP BY anno2 ORDER BY anno2
) tabella
group by anno2 order by anno2