用户44293629(提问者)select
eui.user_code 员工工号,
eui.user_name 员工姓名,
count(case when record_type=\'新训\' then egclr.code else null end ) 新训邀约数量,
count(case when record_type=\'复训\' then egclr.code else null end ) 复训邀约数量,
count(egclr.code ) 邀约数量
from
edw_user_info eui
left join edw_gc_course_lesson_records egclr on eui.user_code=egclr.catch_user_code
and financial_audit_status=\'已审核\'
and egclr.course_lesson_code=case when length(\'${课期}\')=0 then (
select
课期编码
from
(
SELECT
lesson_code 课期编码,
lesson_name 课期名称,
start_date 开课时间,
end_date 结课时间,
free_change_end_date 截至改签时间,
max_count 最大数量
FROM
edw_gc_course_lesson_product egclp
where
to_char(now(),\'YYYY-MM-DD\')<= to_char (free_change_end_date,\'YYYY-MM-DD\')
and course_code=\'K000001\'
and lesson_name not like \'%开课%\'
and lesson_name not like \'%举办%\'
and lesson_name not like \'%暂存%\'
ORDER BY 3 LIMIT 1
)a
) else \'${课期}\' end
where
eui.user_type in (\'公司员工\',\'代理商员工\')
and position_name in (\'业务员\',\'高级业务员\',\'储备经理\')
and eui.status=\'启用\'
and eui.user_code <>\'admin\'
and organization_name=
(select
organization_name
from
edw_user_info
where user_code= \'${fine_username}\'
)
group by 1,2
order by 5 desc