习题目录
SELECT basics quiz SELECT from WORLD Tutorial BBC quiz SELECT from Noble Tutorial Nobel Quiz SELECT within SELECT Tutorial Nested SELECT Quiz SUM and COUNT SUM and COUNT Quiz The JOIN operation JOIN Quiz More JOIN operations JOIN Quiz 2 Using Nul…
链接:https://sqlzoo.net/wiki/More_JOIN_operations 1.
SELECT id, title
FROM movie
WHERE yr1962SELECT yr
FROM movie
WHERE titleCitizen KaneSELECT id,title,yr
FROM movie
WHERE title LIKE Star Trek%SELECT id
FROM actor
WHERE nameGlenn CloseSELECT…
文章目录 SELECT basicsSELECT from WORLDSELECT from NobelSELECT within SELECTSUM and COUNTThe JOIN operationMore JOIN operationsUsing NullSelf join sqlzoo练习题答,已更完。 SELECT basics
The example uses a WHERE clause to show the population of ‘…
话不多说了,今天我要把SQL zoo一顿暴刷!Today is the day! 搞他
附上链接:Welcome to SQL Zoo 一、SELECT from WORLD Tutorial
table内容: in的使用
select name, population
from world
where name in (Sweden,Norway,Denmar…
链接:https://sqlzoo.net/wiki/The_JOIN_operation 1.
SELECT matchid,player
FROM goal
WHERE teamidGERSELECT id,stadium,team1,team2
FROM game
WHERE id1012SELECT goal.player,goal.teamid,game.stadium,game.mdate
FROM game JOIN goal ON (game.idgoal.…
文章目录 1. SELECT from world2. SELECT from Nobel Tutorial3. SELECT in SELECT4. SUM and COUNTMore Exercise 5. JOINMore Exercise 6. More JOIN operations7. Using NULL8. Self JOIN9. Window function 1. SELECT from world Read the notes about this table. Observe…
1. SQLZOO
SELECT basics
使用table如下: #1
The example uses a WHERE clause to show the population of France. Note that strings (pieces of text that are data) should be in single quotes;
Modify it to show the population of Germany:
SELECT po…
数据表:world
namecontinentareapopulationgdpAfghanistanAsia6522302550010020343000000AlbaniaEurope28748283174112960000000AlgeriaAfrica238174137100000188681000000AndorraEurope468781153712000000AngolaAfrica124670020609294100990000000... Q1 Total wo…
SQLZOO练习笔记
在练习过程中,首次出现的语法记录下来,备忘。练习中基础语句的嵌套使用就不在此记录,多练才是王道~
1. Basic
SELCET name, population FROM world
WHERE name Germany;
WHERE name IN (Ireland,Iceland);
WHERE area …