select 	substr(userid,1,8), 
	GROUP_ID, 
	END_DATE 
from gpr
where group_id=100089 
order by end_date
/