select a.usergroup, b.sa_jobx_name, a.user_id, a.user_name, a.user_dept_name
from tb_bi_user a, ssouser.ssomng_view b
where a.user_id=b.sa_user and a.usergroup like '%PL' and b.sa_jobx > 'ECO'
order by a.usergroup;