MySQL按年统计SQL语句

SELECT FROM_UNIXTIME( UNIX_TIMESTAMP(upload_time),'%Y') years,COUNT(*) FROM appinfo where app='APP1' GROUP BY years