select max(au.first_name)'Technician',al.name"Login Name", longtodate(max(acs.opentime))"Last Logged in Time" from aaaaccsession acs left join aaaaccount act on act.account_id=acs.account_id left join aaalogin al on al.login_id=act.login_id left join aaauser au on au.user_id=al.user_id where al.user_id in (select technicianid from helpdeskcrew) group by al.name order by 2 desc;