- 博客(4)
- 收藏
- 关注
原创 Using Null------sqlzoo个人笔记
1.List the teachers who have NULL for their department.select teacher.name from teacherleft join dept on teacher.dept = dept.idwhere dept is null2.Note the INNER JOIN misses the teachers with no department and the departments with no teacher.select t
2020-12-16 10:06:34 81
原创 More JOIN operations------sqlzoo个人笔记
1.List the films where the yr is 1962 [Show id, title]More JOIN operations2.Give year of ‘Citizen Kane’.select yr from moviewhere title = 'Citizen Kane'3.List all of the Star Trek movies, include the id, title and yr (all of these movies include th.
2020-12-06 22:01:20 124
原创 The JOIN operation------sqlzoo个人笔记
4.Show the team1, team2 and player for every goal scored by a player called Mario player LIKE ‘Mario%’select team1 ,team2 ,player from gamejoin goal on game.id=goal.matchidwhere goal.player like 'Mario%'6.List the dates of the matches and the name of.
2020-12-06 11:04:04 89
原创 SUM and COUNT------sqlzoo个人笔记
SUM and COUNT------sqlzoo个人笔记1.Show the total population of the world.select sum(population) from world2.List all the continents - just once each.select distinct continent from world3.Give the total GDP of Africaselect sum(GDP) from worldwhere con
2020-12-03 21:48:08 67
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人