摘要:
1.查询和学号11328、11427同学同年出生的所有学生的stu_num、stu_name、stu_birth; 查询11328与11427: mysql> select * from student where stu_num in (11328,11427); + + + + + + | st 阅读全文
摘要:
1.查询所有学生的stu_name,cour_num,degree列: 其中stu_name字段来自于student表;cour_num和degree字段来自于score表; mysql> select * from student; + + + + + + | stu_num | stu_name 阅读全文
摘要:
1.查询每门课的平均成绩: mysql> select * from course; + + + + | cour_num | cour_name | tea_num | + + + + | 1-245 | Math | 0438 | | 2-271 | Circuit | 0435 | | 3-1 阅读全文