What is all the information about students living in NYC?
select * from student where city_code = "NYC"
What are their gradepoints for the courses they are enrolled in?
select t2.gradepoint from enrolled_in as t1 join gradeconversion as t2 join student as t3 on t1.grade = t2.lettergrade and t1.stuid = t3.stuid where t3.city_code = "NYC"
What are the maximum and minimum?
select max(t2.gradepoint), min(t2.gradepoint) from enrolled_in as t1 join gradeconversion as t2 join student as t3 on t1.grade = t2.lettergrade and t1.stuid = t3.stuid where t3.city_code = "NYC"