meidu2021/daju/target/classes/com/xcgl/reports/sql/XcglRptDao_activitiStatsUserUnFinishedData.sql

select
	 bu.realname as name
	,count(*) as noFinishTaskTotal
from
	ACT_HI_TASKINST hi
	inner join t_s_base_user bu on hi.ASSIGNEE_=bu.username
where hi.END_TIME_ is null

group by bu.ID
order by noFinishTaskTotal desc
limit :rows