izheng000的博客

1.SELECT id, title FROM movie WHERE yr=19622.select yr from movie where title='Citizen Kane'3.select id,title,yr from movie where title like '%Star Trek%' order by yr4.select title from movie where i

1.SELECT name, continent, population FROM world2.SELECT name FROM world WHERE population>2000000003.select name,gdp/population from world where population >=2000000004.SELECT name, population/1000000

转载自SQLZOO(select basics)writeup1.SELECT population FROM world WHERE name = 'Germany'2.SELECT name,gdp/population FROM world WHERE area > 50000003.SELECT name, population FROM world WHERE name IN

转载自SQLZOO（SELECT from Nobel Tutorial）Writeup1.SELECT yr, subject, winner FROM nobel WHERE yr = 19502.SELECT winner FROM nobel WHERE yr = 1962 AND subject = 'Literature'3.select yr,subject from

转载自SQLZOO（SELECT within SELECT Tutorial）Writeup1.SELECT name FROM world WHERE population > (SELECT population FROM world WHERE name='Russia')2.SELECT name FROM world WHERE continent =

转载自SQLZOO(SUM and COUNT)Writeup1.SELECT SUM(population) FROM world2.select DISTINCT(continent) from world3.select sum(gdp) from world where continent ='Africa'4.select count(name) from world where area

转载自SQLZOO（The JOIN operation）Writeup1.SELECT matchid,player FROM goal WHERE teamid = 'GER'2.SELECT id,stadium,team1,team2 FROM game where id=10123.SELECT player,teamid,stadium,mdate FROM game JOI

转载自SQLZOO(Using Null)Writeup1.select name from teacher where dept is null2.SELECT teacher.name, dept.name FROM teacher INNER JOIN dept ON (teacher.dept=dept.id)3.SELECT teacher.name, dept.

转载自SQLZOO(self join)writeup未完1select count(id) from stops2select id from stops where name='Craiglockhart'3.select id,name from stops join route on stops.id=route.stop where route.num=4 and route.compan