![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQLZOO
文章平均质量分 51
weixin_46819300
这个作者很懒,什么都没留下…
展开
-
SQLZOO-DAY5表连接3
1.List the films where theyris 1962 [Showid,title]SELECT id, title FROM movie WHERE yr=19622.Give year of 'Citizen Kane'.SELECT yr FROM movie WHERE title = 'Citizen Kane'3.SELECT yr FROM movie WHERE title = 'Citizen Kane'SELECT id,...原创 2021-06-29 11:40:05 · 77 阅读 · 0 评论 -
SQLZOO-DAY5-表连接练习1
1.The first example shows the goal scored by a player with the last name 'Bender'. The*says to list all the columns in the table - a shorter way of sayingmatchid, teamid, player, gtimeModify it to show thematchidandplayername for all goals score...原创 2021-06-15 19:27:06 · 99 阅读 · 0 评论 -
SQLZOO-DAY4-NULL值练习2
1.One MSP was kicked out of the Labour party and has no party. Find him.SELECT msp.name FROM msp WHERE party IS NULL原创 2021-06-07 11:05:19 · 104 阅读 · 0 评论 -
SQLZOO-DAY4-Null值练习1
1.List the teachers who have NULL for their department.SELECT name FROM teacher WHERE dept IS NULL原创 2021-06-06 20:23:03 · 63 阅读 · 0 评论 -
SQLZOO聚合函数练习2
1.Show the total number of prizes awarded.SELECT COUNT(subject) FROM nobel2.List each subject - just once原创 2021-06-05 17:10:37 · 72 阅读 · 0 评论 -
SQLZOO聚合函数练习1
1.展示世界的總人口。SELECT SUM(population)FROM world2.列出所有的洲份, 每個只有一次。原创 2021-06-05 16:01:42 · 66 阅读 · 0 评论 -
SQLZOO第3天NOBEL子查询
1.紅十字國際委員會 (International Committee of the Red Cross) 曾多次獲得和平獎。 試找出與紅十字國際委員會同年得獎的文學獎(Literature)得獎者和年份。SELECT winner, yr FROM nobelWHERE yr IN(SELECT yr FROM nobel WHERE winner = 'International Committee of the Red Cross') AND subject = 'Literatu...原创 2021-06-04 17:23:05 · 190 阅读 · 0 评论