讨厌吃香菜的小山竹在写文章

分类

/ 注册

全部文章（共27篇）

题解 | #找出每个学校GPA最低的同学#

select device_id ,university ,gpa from ( select *, rank() over (partition by university order by gpa) as rk from user_profile ) a where r...

2024-06-17

0 166

题解 | #截取出年龄#

select substring_index(substring_index(profile, ',', 3), ',', -1) as age ,count(device_id) as number from user_submit group by age

2024-06-17

0 160

题解 | #提取博客URL中的用户名#

select device_id ,substring_index(blog_url, '/', -1) as user_name from user_submit

2024-06-17

0 144

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

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

2024-06-17

0 160

题解 | #计算用户8月每天的练题数量#

select day(date) as day ,count(question_id) as question_cnt from question_practice_detail where date like '2021-08-%' group by date

2024-06-16

0 157

题解 | #计算25岁以上和以下的用户数量#

select case when age < 25 or age is null then '25岁以下' else '25岁及以上' end as age_cut ,count(device_id) as number from user_profile group by ag...

2024-06-16

0 157

题解 | #计算25岁以上和以下的用户数量#

select if(age < 25 or age is null, '25岁以下', '25岁及以上') as age_cut ,count(device_id) as number from user_profile group by age_cut

2024-06-16

0 160