![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
yaci1994
这个作者很懒,什么都没留下…
展开
-
SQLZOO Using_Null 答案
题目网址:https://sqlzoo.net/wiki/Using_Nullselect namefrom teacherwhere dept is nullSELECT teacher.name, dept.name FROM teacher INNER JOIN dept ON (teacher.dept=dept.id)select ...原创 2020-04-25 20:33:35 · 203 阅读 · 0 评论 -
SQLZOO More_JOIN_operations 答案 电影数据库
题目网址:https://sqlzoo.net/wiki/More_JOIN_operations/zhSELECT id, titleFROM movieWHERE yr=1962select yrfrom moviewhere title='Citizen Kane'select id,title,yrfrom moviewhere title lik...原创 2020-04-22 22:08:16 · 299 阅读 · 0 评论 -
SQLZOO The_JOIN_operation 答案 UEFA EURO数据库
SQLZOO The_JOIN_operation 答案 题目网址:https://sqlzoo.net/wiki/The_JOIN_operation/zhSELECT matchid,playerFROM goalWHERE teamid = 'GER'SELECT id,stadium,team1,team2FROM gameWHERE id='1012'...原创 2020-04-21 23:41:28 · 215 阅读 · 0 评论