SELECT D.ID, MAX(D.EMAIL) EMAIL, MAX(D.FIRSTNAME) FIRSTNAME, MAX(D.LASTNAME) LASTNAME
FROM DEVELOPERS D JOIN SKILLCODES S ON S.CODE | D.SKILLCODE = D.SKILLCODE
WHERE CATEGORY = 'Front End'
GROUP BY D.ID
ORDER BY D.ID