SQLZOO-题解

id mdate stadium team1 team2 1001 8 June 2012 National Stadium, Warsaw POL GRE 1002 8 June 2012 Stad

World Country Profile: Aggregate functions name continent area population gdp Afghanistan Asia 65223

SELECT within SELECT Tutorial name continent area population gdp Afghanistan Asia 652230 25500100 20

SELECT name name continent Afghanistan Asia Albania Europe Algeria Africa Andorra Europe Angola Afri

SELECT basics ​ world ​ name continent area population gdp Afghanistan Asia 652230 25500100 20343000