-- 查询所有国家的数量 SELECTCOUNT(country.Code) FROM country;
-- 查询所有语言的数量 SELECTCOUNT(countrylanguage.Language) FROM countrylanguage; SELECTCOUNT(countrylanguage.CountryCode) FROM countrylanguage;
-- 查询China的详细信息(country表) SELECT*FROM country WHERE country.name ='China';
-- 查询属于China的城市信息 SELECT*FROM city WHERE city.CountryCode = (SELECT country.Code FROM country WHERE country.Name ='China');
-- * 查询各大洲的国家数量 SELECTCOUNT(country.Code) FROM country WHERE Continent ='Africa'; SELECTCOUNT(country.Code) FROM country WHERE Continent ='Antarctica'; SELECTCOUNT(country.Code) FROM country WHERE Continent ='Asia'; SELECTCOUNT(country.Code) FROM country WHERE Continent ='Europe'; SELECTCOUNT(country.Code) FROM country WHERE Continent ='North America'; SELECTCOUNT(country.Code) FROM country WHERE Continent ='Oceania'; SELECTCOUNT(country.Code) FROM country WHERE Continent ='South America';
-- 查询所有使用Spanish语言的国家及在此国家使用的比率 SELECT country.Name AS'国家',countrylanguage.Percentage AS'Spanish使用比率'FROM country,countrylanguage WHERE country.Code IN (SELECT CountryCode FROM countrylanguage WHERE countrylanguage.Language ='Spanish');