mysql统计每个月的注册人数

SELECT DATE_FORMAT(reg_time,'%Y-%m'),COUNT(*) FROM user_table GROUP BY DATE_FORMAT(reg_time,'%Y-%m') -- 按月统计，user_table注册表名，reg_time注册时间

1.

SELECT studentNo 学号,studentResult 分数

FROM result

WHERE examDate='2016-02-17'

ORDER BY studentResult DESC

LIMIT 5

2.

SELECT studentName 姓名,YEAR(NOW())-YEAR(bornDate) 年龄,bornDate 出生日期,phone 手机号码

From student

WHERE sex='女'

ORDER BY bornDate ASC

LIMIT 1,6

3.

SELECT YEAR(bornDate) 年份,COUNT(YEAR(bornDate)) 人数

FROM student

GROUP BY YEAR(bornDate)

HAVING COUNT(YEAR(bornDate))>=2

4.

SELECT MAX(studentResult) 最大值,MIN(studentResult) 最小值,AVG(studentResult) 平均值

FROM result

WHERE examDate='2016-02-17'

---