使用ORDB的查询语言,分别写出下列查询的SELECT语句;1)检索每个学生的学习课程和成绩。2)检索至少

Question

使用ORDB的查询语言，分别写出下列查询的SELECT语句；

1)检索每个学生的学习课程和成绩。

2)检索至少有一门课程的求学地与籍贯在同一城市的学生的学号和姓名。

Answer 1

正确答案：1) SELECT A. sname B. coursename B. grade FROM student as A A. studies as B; 2) SELECT A. sno A. sname FROM student as A A. student as B WHERE A. ciy = B. ciy
1) SELECT A. sname, B. coursename, B. grade FROM student as A, A. studies as B; 2) SELECT A. sno, A. sname FROM student as A, A. student as B WHERE A. ciy = B. ciy