少糖去冰啊_

分类

/ 注册

全部文章（共67篇）

题解 | 确定哪些订单购买了 prod_id 为 BR01 的产品（二）

SELECT cust_id, order_date FROM OrderItems O1 LEFT JOIN Orders Ors on O1.order_num = Ors.order_num where prod_id ='BR01' ORDER BY order_date asc

2025-10-14

0 25

题解 | 返回顾客名称和相关订单号以及每个订单的总价

SELECT cus.cust_name, o1.order_num, OrderTotal from Orders o1 LEFT JOIN Customers cus on cus.cust_id = o1.cust_id LEFT JOIN ( SELECT order_num, sum(q...

2025-10-14

0 25

题解 | 返回顾客名称和相关订单号

SELECT cust_name, order_num FROM Customers cus INNER JOIN Orders on cus.cust_id = Orders.cust_id order by cust_name, order_num asc

2025-10-14

0 22

题解 | 从 Products 表中检索所有的产品名称以及对应的销售总数

SELECT prod_name, ( SELECT sum(quantity) FROM OrderItems as O where P.prod_id = O.prod_id ) quant_sold FROM Products as P

2025-10-13

0 23

题解 | 返回每个顾客不同订单的总金额

SELECT cust_id, sum(item_price*quantity) as total_ordered FROM OrderItems O RIGHT JOIN Orders O2 on O.order_num = O2.order_num GROUP BY cust_id ORDER ...

2025-10-13

0 30

题解 | 返回购买 prod_id 为 BR01 的产品的所有顾客的电子邮件（一）

SELECT cust_email from( SELECT cust_id FROM OrderItems OI, Orders O where OI.prod_id = 'BR01' and OI.order_num=O.order_num ) as t1, Custom...

2025-10-13

0 19

题解 | 删除字符串中出现次数最少的字符

strin = input() slist = list(strin) min_list={} for y in slist: min_list[y]=slist.count(y) mins = min(min_list.values()) D=[] for s in strin: ...

2025-09-10

0 32

题解 | 简单密码

from operator import index A='0123456789abcdefghijklmnopqrstuvwxyza' B='ABCDEFGHIJKLMNOPQRSTUVWXYZ' C = input() list3=[] for k in C: if k in A: ...

2025-09-10

0 29

题解 | 简单密码

list1=['a','b','c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 'k', 'l', 'm', 'n', 'o', 'p', 'q', 'r', 's', '...

2025-09-10

0 21

题解 | 字符串排序

num = int(input()) alphm = [] for i in range(num): alphm.append(input()) alphm.sort() ss='\n'.join(alphm) print(ss)

2025-09-10

0 32