What is the maximum grade point of all students who live in NYC?
select max ( 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 is the minimum grade point of all students who live in NYC?
select 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"
What about for students who live in HKG?
select 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 = "HKG"