一查一询

-- 1
#SELECT contryName FROM bbc WHERE population>=200000000;
-- 2
#SELECT contryName,gdp/population FROM bbc WHERE population>=200000000
-- 3
#SELECT contryName,ROUND(population/1000000) FROM bbc WHERE region='South Asia'
-- 4
#SELECT contryName,population FROM bbc WHERE contryName in('france','germany','otaly')
-- 5
#SELECT contryName FROM bbc WHERE contryName LIKE '%united%'
-- 6
#SELECT DISTINCT region FROM bbc
-- 7
#SELECT contryName,population FROM bbc WHERE population>100000000 ORDER BY population DESC


-- nuobei?
-- 1
#SELECT winner FROM nobel WHERE yr='1950'
-- 2 
#SELECT winner FROM nobel WHERE yr='1962'AND SUBJECT='literature'
-- 3
#SELECT yr,SUBJECT FROM nobel WHERE winner='albert einstein'
-- 4
#SELECT winner FROM nobel WHERE SUBJECT='peace' AND yr>=2000
-- 5
#SELECT *FROM nobel WHERE SUBJECT='literature' and yr BETWEEN 1980 and 1989
-- 6
#SELECT *FROM nobel WHERE  winner in ('theodore roosevelt','woodrow wilson','jed bartlet','jimmy carter')
-- 7
#SELECT winner FROM nobel WHERE winner LIKE 'john%'
-- 8
#SELECT DISTINCT SUBJECT FROM nobel 






-- 1
#SELECT SUM(population) FROM bbc
-- 2
#SELECT DISTINCT region FROM bbc
-- 3
#SELECT contryName FROM bbc WHERE gdp>(SELECT SUM(gdp) FROM bbc WHERE region ='africa')
-- 4
#SELECT DISTINCT region,COUNT(contryName) FROM bbc GROUP BY region
-- 5
#SELECT DISTINCT region,SUM(population),SUM(contryarea)fROM bbc GROUP BY region ORDER BY SUM(population)
-- 6
#SELECT DISTINCT region ,COUNT(population) FROM bbc WHERE population>=10000000 GROUP BY region
-- 7
#SELECT DISTINCT region FROM bbc WHERE population>=100000000
-- 8
#SELECT SUM(population),SUM(gdp) FROM bbc WHERE region='europe'
-- 9
#SELECT DISTINCT region ,SUM(population),SUM(contryarea) FROM bbc WHERE contryarea>1000000 GROUP BY region ORDER BY SUM(population)




-- 1
#SELECT DISTINCT COUNT(winner) FROM nobel
-- 2
#SELECT COUNT(SUBJECT) FROM nobel WHERE SUBJECT='physics'
-- 3
#SELECT DISTINCT SUBJECT,COUNT(*) FROM nobel GROUP BY SUBJECT
-- 4
#SELECT DISTINCT SUBJECT, MIN(yr) FROM nobel GROUP BY SUBJECT
-- 5
#SELECT SUBJECT,COUNT(*) FROM nobel WHERE yr=2000 GROUP BY SUBJECT