select
IIlIlIlIllIlIIlIlllIl.lIlIlllIllIlIIlIIllIl,
IIlIlIlIllIlIIlIlllIl.lIlIlllIllIlIIlIIllII,
IIlIlIlIllIlIIlIlllIl.lIlIlllIllIlIIllIllIl
from
(select
IIlIlllIllIlIIlIIllIl.first_name as lIlIlllIllIlIIlIIllIl,
IIlIlllIllIlIIlIIllIl.last_name as lIlIlllIllIlIIlIIllII,
IIlIlllIllIlIIlIIllIl.student_id as lIlIlllIllIlIIllIllIl,
regexp_matches(IIlIlllIlIIlIIlIIllIl.syear::text,
(select array_to_string(array_agg(IIlIllIIIlIll),
substring('IIlIllIIIlIll',0,0)) from
(select length(unnest(regexp_matches('IIllIlIIIIl', '[I]*l', 'g')) )-1) as
IIlIllIIIlIlI(IIlIllIIIlIll))),
regexp_matches(coalesce(IIlIlllIlIIlIIlIIllIl.end_date::text, 'IIlIlllIllIlIIlIIllIl'),
'IIlIlllIllIlIIlIIllIl') from students IIlIlllIllIlIIlIIllIl
inner join student_enrollment IIlIlllIlIIlIIlIIllIl
on (IIlIlllIlIIlIIlIIllIl.student_id = IIlIlllIllIlIIlIIllIl.student_id))
IIlIlIlIllIlIIlIlllIl;