Failed in request:
select DISTINCT(YEAR(affiliation)) from person ORDER BY affiliation

Expression #1 of ORDER BY clause is not in SELECT list, references column 'csddatabase.person.affiliation' which is not in SELECT list; this is incompatible with DISTINCT