刀xiao面_加蛋

1.根据部门查询总人数，男女人数：    SELECT COUNT(1) 总数,           COUNT(CASE SEX                   WHEN '男' THEN                    1                 END) 男生,           COUNT(CASE SEX

查询前三天数据（sysdate-3）；1.SELECT t.create_date FROM fb_appeal t WHERE to_char(t.create_date,'yyyy-mm-dd') >= to_char(SYSDATE-3,'yyyy-mm-dd');2.SELECT t.create_date FROM fb_appeal t WHERE t.create_d