谦虚的比尔在炒股

分类

/ 注册

TA的专栏 0篇文章 0人订阅

sql练习-面试前刷题

0篇文章 0人学习

全部文章（共81篇）

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

select up.device_id,up.university,up.gpa from user_profile up inner join ( select university,min(gpa) min_gpa from user_profile group by u...

2025-05-16

0 32

题解 | 截取出年龄

select profile_age age,count(*) number from ( select substr(profile,12,2) profile_age from user_submit )a group by profile_age

2025-05-16

0 32

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

select device_id,substr(blog_url,11) user_name from user_submit

2025-05-16

0 34

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

select profile_gender gender,count(*) number from ( select substr(profile,15) profile_gender from user_submit )a group by profile_gender

2025-05-16

0 32

题解 | 计算用户的平均次日留存率

select count(if(datediff(b.date,a.date) = 1,a.device_id,null))/count(if(datediff(b.date,a.date) = 0,a.device_id,null)) avg_ret from ( select ...

2025-05-14

0 34

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

select day(date) day, count(question_id) question_cnt from question_practice_detail where month(date) = '08' group by date

2025-05-14

0 32

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

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

2025-05-14

0 31

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

select case when age < 25 or age is null then '25岁以下' else '25岁及以上' end as age_cut, count(*) as number from user_profi...

2025-05-13

0 30

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

select case when age < 25 or age is null then '25岁以下' else '25岁及以上' end as age_cut, count(*) as number from user_profi...

2025-05-13

0 27

题解 | 查找山东大学或者性别为男生的信息

select device_id,gender,age,gpa from user_profile where university = '山东大学' union all select device_id,gender,age,gpa from user_profile where gender =...

2025-05-13

0 35