pad45723的博客

World Country Profile: Aggregate functions（世界国家概况:综合功能）题目7：Counting big countries in each continentFor each continent show the continent and number of countries with populations of at least 10 million.（对于每个大洲，显示大洲和人口数量超过10000万的国家数量）解题7:SELE.

题目3：Neighbours of Argentina and AustraliaList the name and continent of countries in the continents containing either Argentina or Australia. Order by name of the country.解题3：SELECT name, continent FROM world WHERE continent IN (SELECT con...

This tutorial is concerned with a table of Nobel prize winners:（本节关注诺贝尔奖获奖者信息）nobel(yr, subject, winner)题目12:ApostropheFind all details of the prize won by EUGENE O'NEILLEscaping single quotesYou can't put a single quote in a quote strin...

题目5：France, Germany, ItalyShow the name and population for France, Germany, Italy解题5：SELECT name, populationFROM worldWHERE name IN ('France', 'Germany', 'Italy')注意：函数IN的用法，括号()，()内部字符串加引号。题目8：Exclusive OR (XOR). Show the countries ...

SELECT namesThis tutorial uses the LIKE operator to check names. We will be using the SELECT command on the table world: （本节要求在上表world中，使用like操作符进行一些操作。）题目13：Find the capital and the name where the capital includes the name of the country.(查找首都