尹煜

分类

题解(14)

/ 注册

全部文章（共12篇）

题解 | #密码验证合格程序#

''' 1.定义check函数，re.findall正则对应要求2，最后判断重复 2.循环输入字符串并check ''' import re def check(word): if len(word) <= 8: ...

Python3

2022-05-01

0 354

题解 | #返回产品名称和与之相关的订单号#

SELECT p.prod_name, i.order_num FROM Products p LEFT OUTER JOIN OrderItems i USING(prod_id) ORDER BY...

2022-05-01

0 386

题解 | #检索每个顾客的名称和所有的订单号（二）#

#左关联 SELECT c.cust_name, o.order_num FROM Customers c LEFT JOIN Orders o USING(cust_id) ORDER BY c.c...

Mysql

2022-05-01

1 341

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

SELECT c.cust_name,t.order_num,t.OrderTotal FROM (SELECT i.order_num,o.cust_id,i.quantity*i.item_price OrderTotal &nbs...

Mysql

2022-04-28

0 354

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

SELECT p.prod_name,o.quant_sold FROM (SELECT prod_id,SUM(quantity) quant_sold FROM OrderI...

Mysql

2022-04-28

0 367

题解 | #返回购买价格为 10 美元或以上产品的顾客列表#

SELECT d.cust_id FROM OrderItems i,Orders d WHERE i.order_num = d.order_num AND i.item_price >=&n...

Mysql

2022-04-28

26 969

题解 | #确定 Products 表中价格不超过 10 美元的最贵产品的价格#

SELECT max(prod_price) max_price FROM Products WHERE prod_price <= 10

Mysql

2022-04-25

0 375

题解 | #简单错误记录#

list1 = [] while True: try: line = input().split('\\')[-1][-20:] # 加上了数字和空格，所以是-20 ...

Python3

2022-04-24

1 466

题解 | #坐标移动#

list1 = input().split(';') temp = [0,0] words = 'ADWS' def move(word): #具体情况下的移动 ...

Python3

2022-04-24

0 417

题解 | #机器人的运动范围#

n = int(input()) dic = {} for i in range(n): key,value = map(int,input().split('&...

Python3

2022-04-23

0 439