牛客200031181号

分类

/ 注册

全部文章（共17篇）

题解 | 贷款情况

with t as( select city, c.customer_id, loan_amount, loan_type_name, t.loan_type_id from loan_applications a join customers c on a.customer_id = c.c...

2025-10-07

0 11

题解 | 短视频直播间晚上11-12点之间各直播间的在线人数

select a.room_id, room_name, count(*) 'user_count' from( select distinct room_id,user_id from user_view_tb u where out_time >= "2...

2025-09-06

0 17

题解 | 被重复观看次数最多的3个视频

with t as( select cid,sum(watch) 'pv' from( select cid, count(*) 'watch' from play_record_tb p group by cid, uid ...

2025-09-05

0 15

题解 | 网易云音乐推荐(网易校招笔试真题)

with t as( select distinct music_id, music_name from music_likes l join music m on l.music_id = m.id where user_id in (select follower_id from follow...

2025-09-03

0 23

题解 | 统计用户从访问到下单的转化率

with t as( select a.date, visit_cnt, order_cnt from ( select date(visit_time) 'date', count(distinct user_id) 'visit_cnt' from visit_tb group by date...

2025-08-26

0 23

题解 | 某乎问答最大连续回答问题天数大于等于3天的用户及其对应等级

with t as( select author_id, DATE_SUB(answer_date, INTERVAL rk Day) 'continue_day' from( select answer_date, author_id,row_number()ove...

2025-08-18

0 30

题解 | 某乎问答回答过教育类问题的用户里有多少用户回答过职场类问题

with t as( select author_id, issue_type from issue_tb i join answer_tb a on i.issue_id = a.issue_id ) select count(distinct author_id)'...

2025-08-18

0 30

题解 | 单神经元

import math import numpy as np def single_neuron_model(features, labels, weights, bias): #注意广播机制 res = np.dot(features, weights) + bias p...

2025-08-17

1 23

题解 | softmax激活函数实现

import numpy as np import math def softmax(scores: list[float]) -> list[float]: exp_scores = np.exp(scores) probabilities = exp_scores / ...

2025-08-17

1 55

题解 | 牛客直播各科目出勤率

select e.course_id, course_name,round(sum(if_attend) * 100 / sum(if_sign), 2) 'attend_rate(%)' from( select user_id, course_id, if_sign from beh...

2025-08-15

0 29