项目一:查找重复的电子邮箱(难度:简单)
1.创建email表
**代码为:
select email FROM
(SELECT Email,count( * ) FROM email GROUP BY Email HAVING count( * )>1) A
结果为:
项目二:查找大国(难度:简单)
创建world表
代码为:
SELECT name,population,area
FROM world
where area>3000000
or (population>25000000 and gdp>20000000)
结果为: