SQL练习记录

题目

sql语句

 	//1、请统计男女注册多少人（写出SQL）；
    //select count(*) as 总数,sum(yhxb = '09_00003-1') as 男,sum(yhxb = '09_00003-2') as 女 from t_user;

    //2、请统计各月，男女注册多少人（写出SQL）；
    //select DATE_FORMAT(djsj,'%Y-%m') as month,count(*) as 总数,sum(yhxb = '09_00003-1') as 男,sum(yhxb = '09_00003-2') as 女 from t_user group by month;

    //3.请统计各部门、每月男女注册多少人（写出SQL）；
    //select DATE_FORMAT(djsj,'%Y-%m') as month,yhbm as 部门 ,count(*) as 总数,sum(yhxb = '09_00003-1') as 男,sum(yhxb = '09_00003-2') as 女 from t_user group by yhbm,month;