-
查询北京的客户信息,按客户信用积分升序排序
-
查询所有男性客户信息,按身份证号码的降序排序
-
查询有英文名的客户信息,按英文名的升序排序
-
查询每个城市的客户数量
-
查询男性客户的平均信用积分和女性客户的平均信用积分
-
查询信用积分最高的前三名客户信息
-
查询男性客户中,信用积分最低的前三名客户信息
-
查询平均信用积分大于350分的城市名称
SELECT * FROM user WHERE city='北京' ORDER BY credit
SELECT * FROM user WHERE sex='男' ORDER BY personId DESC
SELECT * FROM user WHERE ename!='' ORDER BY ename
SELECT city,COUNT(name) FROM user GROUP BY city
SELECT sex, FROM user GROUP BY sex
SELECT * FROM user ORDER BY credit DESC LIMIT 3
SELECT * FROM user WHERE sex='男' ORDER BY credit LIMIT 3
SELECT v.city,v.f FROM( SELECT city,AVG(credit)f FROM user GROUP BY city)v
WHERE f>350