主题:简单问题?
初学,一个查询语句写不出。
望指点。
thank。
student:
"0104421","周远行","男",1983-07-16 00:00:00,1.83
"0208123","王义平","男",1984-08-20 00:00:00,1.71
"0209120","王大力","男",1983-10-20 00:00:00,1.75
"0309119","李维","女",1986-08-10 00:00:00,1.68
"0309203","欧阳美林","女",1985-06-03 00:00:00,1.62
course:
"cs-110",60,3,"秋"
"cs-201",80,4,"春"
"cs-221",40,2,"秋"
"ee-122",106,5,"秋"
"ee-201",45,2,"春"
sc;
"0104421","cs-110",91.0
"0104421","ee-201",100.0
"0208123","ee-122",91.0
"0208123","ee-201",83.0
"0209120","cs-221",
"0309119","cs-110",72.0
"0309119","cs-201",65.0
"0309203","cs-110",82.5
"0309203","cs-201",80.0
"0309203","ee-201",75.0
查询所有课程的成绩都在80分以上的学生的姓名,学号,且按学号升序排列。
望指点。
thank。
student:
"0104421","周远行","男",1983-07-16 00:00:00,1.83
"0208123","王义平","男",1984-08-20 00:00:00,1.71
"0209120","王大力","男",1983-10-20 00:00:00,1.75
"0309119","李维","女",1986-08-10 00:00:00,1.68
"0309203","欧阳美林","女",1985-06-03 00:00:00,1.62
course:
"cs-110",60,3,"秋"
"cs-201",80,4,"春"
"cs-221",40,2,"秋"
"ee-122",106,5,"秋"
"ee-201",45,2,"春"
sc;
"0104421","cs-110",91.0
"0104421","ee-201",100.0
"0208123","ee-122",91.0
"0208123","ee-201",83.0
"0209120","cs-221",
"0309119","cs-110",72.0
"0309119","cs-201",65.0
"0309203","cs-110",82.5
"0309203","cs-201",80.0
"0309203","ee-201",75.0
查询所有课程的成绩都在80分以上的学生的姓名,学号,且按学号升序排列。