牛客938846508号

分类

/ 注册

全部文章（共32篇）

题解 | #牛客每个人最近的登录日期(三)#

select round(count(distinct b.user_id)/count(*),3) as p from (select user_id #第一次登录用户 ,min(date) from login...

2024-05-04

1 143

题解 | #获取有奖金的员工相关信息。#

select emp_no ,first_name ,last_name ,btype ,salary ,case when e2.btype= 1 then s.salary * 0.1 when e2.btype= 2 then s.salary * 0.2 else s.sal...

2024-05-02

0 158

题解 | #查找最晚入职员工的所有信息#

select * from employees order by hire_date desc limit 1;

2024-04-23

0 109

题解 | #统计复旦用户8月练题情况#

select u.device_id, u.university, count(q.question_id) as question_cnt, sum( case when q.result = 'right' then 1 ...

2024-03-03

0 187

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

SELECT device_id, university, round(gpa, 4) FROM ( select device_id, university, gpa, ...

2024-03-03

0 192

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

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

2024-03-03

0 190

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

select if (profile like '%female', 'female', 'male') as gender, COUNT(*) as number from user_submit group by if (profile like '%female...

2024-03-03

0 172

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

select day (date) as day, count(question_id) as question_cnt from question_practice_detail where year (date) = 2021 and month (dat...

2024-03-03

0 158

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

#第一种SELECT IF (age >= 25, "25岁及以上", "25岁以下") AS age_cut, count(*) AS numberFROM user_profileGROUP BY IF (age >= ...

2024-02-29

1 205

题解 | #统计每个用户的平均刷题数#

① select up.university, qd.difficult_level, round( count(qpd.question_id) / count(distinct qpd.device_id), 4 ) as avg_...

2024-02-29

1 200