select LOGIN_ALIAS.ALIAS as ""
from ROLE inner join PERSON_ROLE on PERSON_ROLE.KEY_ROLE = ROLE.ID_INTERNAL
inner join PARTY on PARTY.ID_INTERNAL = PERSON_ROLE.KEY_PERSON
inner join USER on USER.ID_INTERNAL = PARTY.KEY_USER
inner join IDENTIFICATION on IDENTIFICATION.KEY_USER = USER.ID_INTERNAL
inner join LOGIN_ALIAS on LOGIN_ALIAS.KEY_LOGIN = IDENTIFICATION.ID_INTERNAL
where ROLE.ROLE_TYPE = 'STUDENT'
and LOGIN_ALIAS.ALIAS like 'l%';