MySQL - 03.数据定义语言（Data Definition Language，DDL）

1. 库的管理

2. 表的管理

#分组查询

#SELECT 分组函数，分组后的字段
#FROM 表
#WHERE 筛选条件
#GROUP BY 分组的字段
#HAVING 分组后的筛选
#ORDER BY 排序列表

SELECT world.country.Continent,MAX(world.country.SurfaceArea)
FROM world.country
GROUP BY world.country.Continent;

SELECT world.country.Continent,AVG(world.country.SurfaceArea)
FROM world.country
WHERE world.country.Continent LIKE "%a%"
GROUP BY world.country.Continent;

#先查询每个大洲有多少个国家，再查询哪个大洲上的国家数大于30
SELECT COUNT(*),world.country.Continent
FROM world.country
GROUP BY world.country.Continent
HAVING COUNT(*)>30;

SELECT COUNT(*),world.country.Continent
FROM world.country
WHERE world.country.IndepYear IS NOT NULL
GROUP BY world.country.Continent
HAVING COUNT(*)>30;
#根据原始表筛选用WHERE，根据生成表筛选用HAVING

SELECT COUNT(*),LENGTH(world.country.`Name`)
FROM world.country
GROUP BY LENGTH(world.country.`Name`)
HAVING COUNT(*)>10;

SELECT MAX(world.country.SurfaceArea),world.country.Continent,LENGTH(world.country.`Name`)
FROM world.country
GROUP BY	world.country.Continent,LENGTH(world.country.`Name`)
HAVING MAX(world.country.SurfaceArea)>1000000
ORDER BY MAX(world.country.SurfaceArea) DESC;