白加黑__

分类

/ 注册

全部文章（共49篇）

题解 | 禁止重复注册

current_users = ['Niuniu', 'Niumei', 'GURR', 'LOLO'] new_users = ['GurR', 'Niu Ke Le', 'LoLo', 'Tuo Rui Chi'] upper_current_users = [x.upper() for x i...

2025-02-23

0 59

题解 | 判断列表是否为空

my_list = [] if len(my_list) != 0: print('my_list is not empty!') elif len(my_list) == 0: print('my_list is empty!')

2025-02-23

0 65

题解 | 判断布尔值

a = bool(int(input())) if a == 1: print("Hello World!") elif a == 0: print("Erros!")

2025-02-23

0 68

题解 | 统计快递运输时长

SELECT et.exp_type, ROUND(AVG(TIMESTAMPDIFF(MINUTE, out_time, in_time)/60),1) time FROM express_tb et JOIN exp_action_tb eat ON et.exp_number ...

2025-02-23

0 54

题解 | 查询产生理赔费用的快递信息

SELECT et.exp_number, et.exp_type, ect.claims_cost FROM express_tb et JOIN exp_cost_tb ect ON et.exp_number = ect.exp_number WHERE insuran...

2025-02-23

0 58

题解 | 完成员工考核试卷突出的非领导员工

SELECT er.emp_id, emp.emp_level, t1.tag exam_tag FROM (SELECT ei.exam_id, ei.tag , AVG(er.score) avg_score, ...

2025-02-22

0 65

题解 | 淘宝店铺的实际销售额与客单价

SELECT SUM(st.sales_num * gt.goods_price) sales_total, SUM(st.sales_num * gt.goods_price)/COUNT(DISTINCT user_id) per_trans FROM sales_tb st J...

2025-02-22

0 61

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

SELECT rt.room_id, rt.room_name, COUNT(DISTINCT user_id) user_count FROM user_view_tb ut JOIN room_info_tb rt ON ut.room_id = rt.room_id W...

2025-02-22

0 78

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

SELECT t1.cid, pv, ROW_NUMBER() OVER(ORDER BY pv DESC, ct.release_date DESC) rk FROM (SELECT cid, CAST(COUNT(*) AS...

2025-02-16

1 58