学习生1

分类

/ 注册

全部文章（共175篇）

题解 | #链表内指定区间反转#

# class ListNode: # def __init__(self, x): # self.val = x # self.next = None # # 代码中的类名、方法名、参数名已经指定，请勿修改，直接返回方法规定的值即可 # # # @para...

2024-11-28

0 34

题解 | #反转链表#

# class ListNode: # def __init__(self, x): # self.val = x # self.next = None # # 代码中的类名、方法名、参数名已经指定，请勿修改，直接返回方法规定的值即可 # # # @para...

2024-11-28

0 49

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

select cust_id, order_date from Orders join OrderItems on OrderItems.order_num=Orders.order_num where OrderItems.prod_id='BR01' order by...

2024-11-26

0 59

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

select Customers.cust_name as cust_name, Orders.order_num as order_num, OrderItems.quantity*OrderItems.item_price as OrderTotal from O...

2024-11-26

0 56

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

select Customers.cust_name as cust_name, Orders.order_num as order_num from Customers inner join Orders on Customers.cust_id=Orders.cust_...

2024-11-26

0 66

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

select cust_id, order_date from Orders join OrderItems on OrderItems.order_num=Orders.order_num where OrderItems.prod_id='BR01' order by...

2024-11-26

0 51

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

select Customers.cust_name as cust_name, Orders.order_num as order_num, OrderItems.quantity*OrderItems.item_price as OrderTotal from O...

2024-11-26

0 36

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

select Customers.cust_name as cust_name, Orders.order_num as order_num from Customers inner join Orders on Customers.cust_id=Orders.cust_...

2024-11-26

0 50

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

select Customers.cust_name as cust_name, Orders.order_num as order_num from Customers inner join Orders on Customers.cust_id=Orders.cust_...

2024-11-26

0 39

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

select Products.prod_name as prod_name, sum(OrderItems.quantity) as quant_sold from Products,OrderItems where Products.prod_id=OrderItems....

2024-11-26

0 62