genus, species select firstname, middlename, lastname, date_of_birth, (select name from schools s where p.school = s.id) schoolname Chapter 6. Data Manipulation-Statements (DML) 248 from pupils (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