查询家在其他地方的学生中比家在北京的所有学生年龄都小的学生名单。

Question

查询家在其他地方的学生中比家在北京的所有学生年龄都小的学生名单。

Answer 1

正确答案：SELECT SNAME 2005--BIRTH _ YEAR FROM STUDENT WHERE BIRTH_YEAR＞ ALL (SELECT BIRTH_YEAR FROM STUDENT WHEREADDRESS='北京') AND ADDRESS＞'北京' ORDER BY 2005—BIRTH_EAR DESC；
SELECT SNAME, 2005--BIRTH _ YEAR FROM STUDENT WHERE BIRTH_YEAR＞ ALL (SELECT BIRTH_YEAR FROM STUDENT WHEREADDRESS='北京') AND ADDRESS＞'北京' ORDER BY 2005—BIRTH_EAR DESC；