查询所有

SELECT DATE_FORMAT(START_time,'%Y') time,COUNT(id)

FROM cti_record_files GROUP BY time

条件查询

SELECT DATE_FORMAT(START_time,'%Y') time,COUNT(id)

FROM cti_record_files WHERE

DATE_FORMAT(emotional_time, '%Y') >= '2018'

AND DATE_FORMAT(emotional_time, '%Y') <= '2020'

GROUP BY time

这个条件只是对时间做出限制，但所有录音均为超出这个时间段