SQLZOO
文章平均质量分 51
weixin_46819300
这个作者很懒,什么都没留下…
展开
-
SQLZOO-DAY5表连接3
1. List the films where theyris 1962 [Showid,title] SELECT id, title FROM movie WHERE yr=1962 2. 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 · 63 阅读 · 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, gtime Modify it to show thematchidandplayername for all goals score...原创 2021-06-15 19:27:06 · 82 阅读 · 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 · 89 阅读 · 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 · 53 阅读 · 0 评论 -
SQLZOO聚合函数练习2
1. Show the total number of prizes awarded. SELECT COUNT(subject) FROM nobel 2. List each subject - just once原创 2021-06-05 17:10:37 · 67 阅读 · 0 评论 -
SQLZOO聚合函数练习1
1. 展示世界的總人口。 SELECT SUM(population) FROM world 2. 列出所有的洲份, 每個只有一次。原创 2021-06-05 16:01:42 · 58 阅读 · 0 评论 -
SQLZOO第3天NOBEL子查询
1. 紅十字國際委員會 (International Committee of the Red Cross) 曾多次獲得和平獎。 試找出與紅十字國際委員會同年得獎的文學獎(Literature)得獎者和年份。 SELECT winner, yr FROM nobel WHERE yr IN (SELECT yr FROM nobel WHERE winner = 'International Committee of the Red Cross') AND subject = 'Literatu...原创 2021-06-04 17:23:05 · 172 阅读 · 0 评论