小燕子my

分类

/ 注册

全部文章（共137篇）

题解 | #成绩输入输出#

num1=input().split() print('score1='+num1[0]+',score2='+num1[1]+',score3='+num1[2])

2024-10-22

0 43

题解 | #查询连续入住多晚的客户信息？#

SELECT B.user_id, B.room_id, A.room_type, DATEDIFF (checkout_time, checkin_time) AS days FROM guestroom_tb A JOIN checkin_tb B...

2024-10-19

0 48

题解 | #统计各岗位员工平均工作时长#

SELECT A.post,AVG(TIMESTAMPDIFF(MINUTE,B.first_clockin,B.last_clockin)/60) AS work_hours FROM staff_tb A JOIN attendent_tb B ON A.staff_id=B.staff_id ...

2024-10-19

0 58

题解 | #每个商品的销售总额#

SELECT A.name AS product_name, SUM(B.quantity) AS total_sales, RANK() OVER ( partition BY A.category ORDER BY ...

2024-10-19

0 46

题解 | #推荐内容准确的用户平均评分#

-- 小心踩坑：（1）准确定义：推荐的内容标签与用户喜好标签一致；如推荐多次给同一用户，有一次及以上准确就归为准确。 SELECT AVG(DISTINCT(B.score)) FROM recommend_tb A JOIN user_action_tb B ON A.rec_user=B.us...

2024-10-19

0 48

题解 | #查询培训指定课程的员工信息#

SELECT A.staff_id,B.staff_name FROM (SELECT info_id,staff_id, IF(course LIKE '%1%',1,0) AS course1, IF(course LIKE '%2%',1,0) AS course2, IF(course L...

2024-10-19

0 45

题解 | #统计所有课程参加培训人次#

SELECT SUM(course1)+SUM(course2)+SUM(course3) AS staff_nums FROM ( SELECT info_id, staff_id, IF (course LIKE '%1%', 1, 0) ...

2024-10-19

0 50

题解 | #获取指定客户每月的消费额#

SELECT DATE_FORMAT(C.t_time,'%Y-%m') AS time,SUM(C.t_amount) AS total FROM (SELECT * FROM (SELECT * FROM trade)A JOIN (SELECT * FROM customer)B ON A.t...

2024-10-18

0 40

题解 | #打印文件的最后5行#

# 查看文件后五行 tail -5 nowcoder.txt # 查看文件前五行 head -5 nowcoder.txt

2024-10-17

0 41

题解 | #查找两个字符串a,b中的最长公共子串#

# 第一步：获取两个入参，以及两个入参长度 num1=input() num2=input() length1,length2=len(num1),len(num2) # 第二步：判断两个入参大小。小的在第一个，大的在第二个 if length2<length1: length1,l...

2024-09-08

0 108