- 博客(7)
- 收藏
- 关注
原创 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
原创 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
原创 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
原创 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
原创 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
原创 SQLZOO聚合函数练习1
1.展示世界的總人口。SELECT SUM(population)FROM world2.列出所有的洲份, 每個只有一次。
2021-06-05 16:01:42
66
原创 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
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人