题解 | #统计每种性别的人数#

第一种比较笨笨

```select 'female' as gender, count(*) as number
       from user_submit 
        where profile like '%female'
        union all
    select 'male' as gender, count(*) as number
       from user_submit 
       where profile not like '%female'
       order by number
第二种：
```js
   select 'female' as gender, count(*) as number
       from user_submit 
        where profile like '%female'
        union all
    select 'male' as gender, count(*) as number
       from user_submit 
       where profile not like '%female'
       order by number