Yuty
Yuty
全部文章
分类
题解(27)
归档
标签
去牛客网
登录
/
注册
Yuty的博客
全部文章
(共27篇)
题解 | #实习广场投递简历分析(三)#
# # 1,t1,查询在2025年投递简历的每个岗位,每一个月内收到简历的数目 # select job, # date_format(date, '%Y-%m') as first_year_mon, # date_format(date, '%m') as first_mon, # sum(nu...
Mysql
2022-01-08
0
221
题解 | #考试分数(五)#
select * from ( select *, dense_rank() over(partition by job order by score desc) as t_rank from grade ) as t3 where (job, t3.t_rank)...
Mysql
2022-01-06
0
236
题解 | #考试分数(四)#
背景知识 中位数的计算方法: https://baike.baidu.com/item/%E4%B8%AD%E4%BD%8D%E6%95%B0/3087401?fr=aladdin # # 1,t1,查询每个岗位分别有多少人 # select job, count(distinct id) as j...
Mysql
2022-01-05
0
198
题解 | #牛客每个人最近的登录日期(五)#
# # 步骤1,t1,查询每个用户的初次登录日期 # select user_id, min(date) as min_date # from login # group by user_id # # 步骤2,t2,查询每个日期的新用户 # select date, # (case when lo...
Mysql
2022-01-04
0
255
题解 | #牛客每个人最近的登录日期(四)#
# # 步骤一,找出每个用户的初次登录日期 # select user_id, min(date) as min_date # from login # group by user_id; # 步骤二,查询每个日期登录新用户个数,并且查询结果按照日期升序排序 select login.date, ...
Mysql
2022-01-04
0
253
题解 | #牛客每个人最近的登录日期(三)#
# # 步骤一,当前日期加一天的date1,与当前日期对比:找出日期一致的user_id # select user_id, date_add(date, interval +1 day) as date1 # from login # having (user_id, date1) in (sel...
Mysql
2022-01-04
0
208
题解 | #获取员工其当前的薪水比其manager当前薪水还高的相关信息#
# # 步骤一:员工和薪水 # select dept_no, emp_no, salary as emp_salary # from dept_emp # left join salaries using(emp_no) # where to_date = '9999-01-01' # # 步骤...
Mysql
2021-12-17
0
256
题解 | #牛客直播开始时各直播间在线人数#
select ct.course_id, ct.course_name, sum(case when ((hour(att.in_datetime) < 19 and hour(att.out_datetime) >= 19) or (hour(att.in_datetime) = 19...
Mysql
2021-12-13
0
235
题解 | #某宝店铺折扣率#
# 步骤一:拉表格列出每一单的实际价格结算金额和标签价格结算金额 # select sales_price, pt.tag_price*st.sales_num as tag_sales_price # from sales_tb as st # left join product_tb as pt...
Mysql
2021-12-10
0
289
题解 | #每个城市中评分最高的司机信息#
# 步骤一 # select # city, # driver_id, # round(avg(grade),1) as avg_grade, # round(count(co.driver_id) / count(distinct DATE_FORMAT(order_time, '%Y-%m-%d...
Mysql
2021-12-08
0
319
首页
上一页
1
2
3
下一页
末页