用了啥纪录啥
非a,b开头的,city 去重
select distinct city from station where city regexp "^(a|b)"
取id为偶数的条目
select * from table where id mod 2 = 0
5 div 2 取整除结果
5 mod 2 取余数
round(2.9) 四舍五入
统计重复的name 条数
select ((select count (*) from table) - (select count(distinct name) from table))
count(distinct name) 去重统计
按照city 名字长度排序,第二优先级按city 字符排序, 取第一条
select city from station order by CHAR_LENGTH(city) desc, city asc limit 1