(substring(now(),1,4)-substring(ts.idcard,7,4))-(substring(ts.idcard,11,4)-date_format(now(),'%m%d')>0) <25 ) age25DownCount
select
td.district,
count(1) sumCount,
(select count(1) from ods_dsznh_t_training_studentinfo ts
INNER JOIN ods_dsznh_t_training_driverschool tdd on tdd.id = ts.driverschoolid where tdd.district = td.district AND ts.applydate <= #{rrTimeEnd} ) sumCountRr,
(select count(1) from ods_dsznh_t_training_studentinfo ts
INNER JOIN ods_dsznh_t_training_driverschool tdd on tdd.id = ts.driverschoolid where tdd.district = td.district AND ts.sex = 1 AND ts.applydate <= #{query.endTime} ) sumMan,
(select count(1) from ods_dsznh_t_training_studentinfo ts
INNER JOIN ods_dsznh_t_training_driverschool tdd on tdd.id = ts.driverschoolid where tdd.district = td.district AND ts.sex = 2 AND ts.applydate <= #{query.endTime} ) sumWoman,
(select count(1) from ods_dsznh_t_training_studentinfo ts
INNER JOIN ods_dsznh_t_training_driverschool tdd on tdd.id = ts.driverschoolid where tdd.district = td.district AND ts.applydate <= #{query.endTime}
AND (substring(now(),1,4)-substring(ts.idcard,7,4))-(substring(ts.idcard,11,4)-date_format(now(),'%m%d')>0) <25 ) age25DownCount,
(select count(1) from ods_dsznh_t_training_studentinfo ts
INNER JOIN ods_dsznh_t_training_driverschool tdd on tdd.id = ts.driverschoolid where tdd.district = td.district AND ts.applydate <= #{query.endTime}
AND (substring(now(),1,4)-substring(ts.idcard,7,4))-(substring(ts.idcard,11,4)-date_format(now(),'%m%d')>0) >25
AND (substring(now(),1,4)-substring(ts.idcard,7,4))-(substring(ts.idcard,11,4)-date_format(now(),'%m%d')>0) <55 ) age2555DownCount,
(select count(1) from ods_dsznh_t_training_studentinfo ts
INNER JOIN ods_dsznh_t_training_driverschool tdd on tdd.id = ts.driverschoolid where tdd.district = td.district AND ts.applydate <= #{query.endTime}
AND (substring(now(),1,4)-substring(ts.idcard,7,4))-(substring(ts.idcard,11,4)-date_format(now(),'%m%d')>0) >55 ) age55UpCount
from ods_dsznh_t_training_studentinfo ts
INNER JOIN ods_dsznh_t_training_driverschool td on td.id = ts.driverschoolid
where ts.applydate <= #{query.endTime}
<if test="@com.traffic.admin.business.util.CommonUtil@isNotNull(query.district)">
AND td.district = #{query.district}
</if>
GROUP BY td.district