~~~ select * from students where age > (select avg(age) from students); ~~~ ~~~ select name from classes where id in (select cls_id from students); ~~~ ~~~ select * from students where (height,age) = (select max(height),max(age) from students); ~~~