杨~~

分类

题解(4)

/ 注册

全部文章（共15篇）

题解 | #哪些订单购买了 prod_id 为 BR01 #

select Orders.cust_id, order_date from OrderItems, Orders where OrderItems.order_num = Orders.order_num and OrderItems.prod_id...

2023-06-07

1 236

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

select Orders.cust_id from OrderItems, Orders where OrderItems.order_num = Orders.order_num and OrderItems.item_price >= 10

2023-06-07

0 215

题解 | #计算总和#

select order_num,sum(item_price * quantity) as 'total_price' from OrderItems group by order_num having total_price >= 1000 order by order_num

2023-06-07

1 220

题解 | #返回订单数量总和不小于100的所有订单的订单号#

select t.order_num from (select order_num,sum(quantity) as 'sum' from OrderItems group by order_num) as t where t.sum >= 100 order by t.order_num

2023-06-07

0 203

题解 | #每个供应商成本最低的产品#

select vend_id,min(prod_price) as 'cheapest_item' from Products group by vend_id order by cheapest_item

2023-06-07

1 270

题解 | #返回每个订单号各有多少行数#

select order_num,count(order_num) as 'order_lines' from OrderItems group by order_num order by order_lines

2023-06-07

1 254

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

select max(t.prod_price) as 'max_price' from (select * from Products where prod_price <=10) as t

2023-06-07

1 416

题解 | #确定已售出产品项 BR01 的总数#

select sum(quantity) as 'items_ordered' from OrderItems where prod_id = 'BR01' group by prod_id

2023-06-07

0 316

题解 | #返回 2020 年 1 月的所有订单的订单信息#

select * from Orders where substring(order_date,7,1) = '1' order by order_date

2023-06-07

1 228

题解 | #顾客登录名#

select cust_id,cust_name,upper(concat(substring(cust_contact,1,2),substring(cust_city,1,3))) as 'user_login' from Customers

2023-06-07

1 210