熊猫不如猫熊

分类

/ 注册

全部文章（共77篇）

题解 | #统计每个学校的答过题的用户的平均答题数#

select u.university ,count(qp.question_id)/count(distinct(u.device_id)) from question_practice_detail qp left join user_profile u on u.d...

2024-08-31

0 96

题解 | #21年8月份练题总数#

select count(distinct(device_id)) ,count(question_id) from question_practice_detail where left(date,7)='2021-08'

2024-08-31

0 114

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

select substring_index(profile,',',-1) as gender ,count(*) from user_submit group by 1

2024-08-31

0 88

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

select case when profile like '%female%' then 'female' when profile like '%male%' then 'male' else '未知' end gender ,count(*) fro...

2024-08-31

0 105

题解 | #查看不同年龄段的用户明细#

select device_id,gender, case when age<20 then '20岁以下' when age>=20 and age<=24 then '20-24岁' when age&g...

2024-08-30

0 102

题解 | #商品交易(网易校招笔试真题)#

select t.goods_id,g.name,g.weight,sum(count) as total from trans t left join goods g on g.id=t.goods_id where g.weight<50 group by 1,2 having ...

2024-08-30

0 102

题解 | #今天的刷题量(一)#

select t2.name,count(t1.subject_id) as cnt from submission t1 left join subject t2 on t1.subject_id=t2.id where create_time=current_date group by...

2024-08-30

0 115