白加黑__

分类

/ 注册

全部文章（共49篇）

题解 | 格式化清单

eat_lst = ['apple', 'ice cream', 'watermelon', 'chips', 'hotdogs', 'hotpot'] while len(eat_lst) > 0: eat_lst.pop(-1) print(eat_lst)

2025-02-25

0 49

题解 | 2的次方数

my_list = [2**i for i in range(1,11)] for num in my_list: print(num)

2025-02-25

0 67

题解 | 被5整除的数字

my_list = list(range(5,51,5)) for i in my_list: print(i)

2025-02-25

0 59

题解 | 前10个偶数

my_list = list(range(0,19,2)) for i in my_list: print(i)

2025-02-25

0 86

题解 | 商品价格排名

SELECT product_id, product_name, type, price FROM (SELECT product_id, product_name, type, price, ...

2025-02-25

11 52

题解 | 用户购买次数前三

SELECT DISTINCT uid, COUNT(*) cnt FROM user_client_log ucl WHERE step = 'order' GROUP BY uid ORDER BY cnt DESC, uid LIMIT 3

2025-02-25

0 71

题解 | 下单最多的商品

SELECT product_id, COUNT(DISTINCT uid) cnt FROM user_client_log ucl WHERE step = 'order' GROUP BY product_id ORDER BY product_id LIMIT 1

2025-02-24

0 55

题解 | 统计快递从创建订单到发出间隔时长

SELECT ROUND(AVG(TIMESTAMPDIFF(MINUTE, create_time, out_time))/60,3) time FROM express_tb et JOIN exp_action_tb eat ON et.exp_number = eat.exp_number

2025-02-24

0 64

题解 | 验证登录名与密码

name = input() code = input() if name == 'admis' and code == 'Nowcoder666': print('Welcome!') else: print('user id or password is not correct!...

2025-02-23

0 59

题解 | 牛牛的绩点

score_dict = {"A":4.0, "B":3.0, "C":2.0, "D":1.0, "F":0} score = 0 score_lst = [] mark_lst = [] whil...

2025-02-23

0 56