lizhenzhen

分类

/ 注册

全部文章（共65篇）

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

select cust_id,order_date from OrderItems join Orders using(order_num) where prod_id='BR01' order by order_date;

2025-12-29

0 25

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

select cust_id from OrderItems t1 join Orders t2 using(order_num) where item_price>=10;

2025-12-29

0 26

题解 | 纠错3

SELECT order_num, COUNT(*) AS items FROM OrderItems GROUP BY order_num HAVING COUNT(*) >= 3 ORDER BY items, order_num;

2025-12-29

0 29

题解 | 计算总和

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

2025-12-29

0 24

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

select order_num from OrderItems group by order_num having sum(quantity)>=100 order by order_num;

2025-12-29

0 23

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

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

2025-12-29

0 29

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

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

2025-12-29

0 25

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

select max(prod_price) as max_price from Products where prod_price<=10;

2025-12-29

0 25

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

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

2025-12-29

0 26

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

select sum(quantity) as items_ordered from OrderItems;

2025-12-29

0 28