2020/11/14 刘一辰的JAVA随笔

今日目标：Mysql学习18

实验内容：

-- 13.查询分数大于70但是小于90的s_no列:

SELECT s_no,sc_degree  FROM score WHERE sc_degree BETWEEN 71 AND 89;

+------+-----------+

| s_no | sc_degree |

+------+-----------+

| 103  |        86 |

| 103  |        85 |

| 105  |        88 |

| 105  |        75 |

| 105  |        79 |

| 109  |        76 |

| 109  |        81 |

+------+-----------+

 

进阶:显示s_name,c_name

select s_name,sc_degree,c_name FROM score,student,course WHERE score.s_no = student.s_no AND score.c_no = course.c_no AND sc_degree BETWEEN 71 AND 89;

+--------+-----------+------------+

| s_name | sc_degree | c_name     |

+--------+-----------+------------+

| 王丽   |        86 | 操作系统   |

| 王丽   |        85 | 数字电路   |

| 王芳   |        88 | 计算机导论 |

| 王芳   |        75 | 操作系统   |

| 王芳   |        79 | 数字电路   |

| 赵铁柱 |        76 | 计算机导论 |

| 赵铁柱 |        81 | 数字电路   |

+--------+-----------+------------+