1select year(uploadtime) as yy,count(*),sum(filetypeid) from sys_base_fileindex GROUP BY yy
21
1select
2 to_char(a.create_date,'yyyy') as date_year,
3 count(*) as num
4from sys_bug a
5left join sys_user u on u.id = a.create_by
6left join sys_office o on o.id = u.office_id
7group by to_char(a.create_date,'yyyy')
81234567