徐若离
徐若离
全部文章
分类
题解(20)
归档
标签
去牛客网
登录
/
注册
徐若离的博客
全部文章
(共15篇)
题解 | #统计每种性别的人数#
SELECT SUBSTRING(profile FROM 15 FOR 6) AS gender, COUNT(blog_url) AS number FROM user_submit GROUP BY gender;
Mysql
2022-01-18
0
207
题解 | #计算用户8月每天的练题数量#
SELECT EXTRACT(DAY FROM date) AS day, COUNT(question_id) AS question_cnt FROM question_practice_detail WHERE date BETWEEN '2021-08-01' AND '2021-08-31...
Mysql
2022-01-18
0
156
题解 | #查看不同年龄段的用户明细#
SELECT device_id,gender, CASE WHEN age<20 THEN '20岁以下' WHEN age BETWEEN 20 AND 24 THEN '20-24岁' WHEN age>=25 THEN '25岁及以上' ELSE '其他' END AS age_...
Mysql
2022-01-18
0
188
题解 | #计算25岁以上和以下的用户数量#
SELECT CASE WHEN age<25 OR age is NULL THEN '25岁以下' WHEN age>=25 THEN '25岁及以上' ELSE NULL END AS age_cnt, count(*) AS number FROM user_profile...
Mysql
2022-01-18
0
156
题解 | #分组过滤练习题#
SELECT university,AVG(question_cnt) AS avg_question_cnt,AVG(answer_cnt) AS avg_answer_cnt FROM user_profile GROUP BY university HAVING avg_question_cn...
Mysql
2021-12-07
0
152
首页
上一页
1
2
下一页
末页