牛客616740729号
牛客616740729号
全部文章
分类
题解(6)
归档
标签
去牛客网
登录
/
注册
牛客616740729号的博客
全部文章
(共3篇)
题解 | #统计每种性别的人数#
select 'male' as gender,count(profile) as number from user_submit where profile like '%,male' union select 'female' as gender,count(profile) as numbe...
Mysql
2021-11-29
0
169
题解 | #查看不同年龄段的用户明细#
select device_id,gender,age_cut from ( select id,device_id,gender,'20岁以下' age_cut ...
Mysql
2021-11-26
0
210
题解 | #统计每个学校各难度的用户平均刷题数#
SELECT uu university,dl difficult_level,avg(cc) avg_answer_cnt FROM(SELECT u.university uu,u.device_id,qpd_qd.d_lev dl,count(*) cc FROM user_profi...
Mysql
2021-11-24
0
196