genus, species SELECT firstname, middlename, lastname, date_of_birth, (SELECT name FROM schools s WHERE p.school = s.id) schoolname FROM pupils p WHERE year_started = 2012 ORDER BY schoolname, IN (1880, 1881) OR birthyear BETWEEN 1891 AND 1898; SELECT name, street, borough, phone FROM schools s WHERE EXISTS (SELECT * FROM pupils p WHERE p.school = s.id) ORDER BY borough, street; SELECT