zy1206_c的博客

https://sqlzoo.net/wiki/SQLZOO:SELECT_from_WORLD_Tutorial/zh --第一题 SELECT name, continent, population FROM world --第二题 SELECT name FROM world WHERE population>200000000 --第三题 SELECT name,GDP/population FROM world WHERE population>200000000 --第四

https://sqlzoo.net/wiki/SELECT_from_Nobel_Tutorial/zh --第一题 SELECT yr, subject, winner FROM nobel WHERE yr = 1950 --第二题 SELECT winner FROM nobel WHERE yr = 1962 AND subject='Literature' --第三题 SELECT yr,subject FROM nobel WHERE winner='Albert Einstein'