Bigder

分类

/ 注册

全部文章（共33篇）

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

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

2023-05-14

2 200

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

SELECT order_num,count(*) as order_lines FROM OrderItems group by order_num order by order_lines

2023-05-14

1 221

题解 | #返回所有订单的订单号和订单日期#

select order_num, order_date from Orders where date_format(order_date,'%Y%m') ='202001' order by order_date #【问题】编写 SQL 语句，返回 2020...

2023-05-13

1 332

题解 | #检索并列出已订购产品的清单#

#【问题】编写SQL 语句，查找所有订购了数量至少100 个的 BR01、BR02 或BR03 的订单。你需要返回 OrderItems 表的订单号（order_num）、产品 ID（prod_id）和数量（quantity），并按产品 ID 和数量进行过滤 select order_num...

2023-05-12

1 278

题解 | #检索并列出已订购产品的清单#

select order_num,prod_id,quantity from OrderItems where prod_id in ('BR01','BR02','BR03') and quantity>=100

2023-05-12

1 219

题解 | #检索供应商名称#

#编写 SQL 语句，从 Vendors 表中检索供应商名称（vend_name），仅返回加利福尼亚州的供应商（这需要按国家[USA]和州[CA]进行过滤，没准其他国家也存在一个CA） select vend_name from Vendors where vend_coun...

2023-05-12

1 327

题解 | #检索供应商名称#

select vend_name from Vendors where vend_country = 'USA' and vend_state = 'CA'

2023-05-12

1 226

题解 | #返回更多的产品#

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

2023-05-12

1 192

题解 | #返回产品并且按照价格排序#

select prod_name,prod_price from Products where prod_price <=6 and prod_price >=3

2023-05-12

1 264

题解 | #返回固定价格的产品#

SELECT prod_id, prod_name FROM Products WHERE prod_price = 9.49

2023-05-12

1 220