阿莉勒丝黛拉

分类

题解(169)

/ 注册

全部文章（共128篇）

题解 | #检索产品名称和描述（一）#

SELECT prod_name, prod_desc FROM Products WHERE prod_d...

Mysql

2022-03-05

1 940

题解 | #纠错2#

SELECT vend_name FROM Vendors WHERE vend_country = 'USA' AND &n...

Mysql

2022-03-05

1 651

题解 | #返回所有价格在 3美元到 6美元之间的产品的名称和价格#

# SELECT # prod_name, # prod_price # FROM # Products ...

Mysql

2022-03-05

19 1010

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

SELECT order_num, prod_id, quantity FROM OrderItems WH...

Mysql

2022-03-05

41 2374

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

SELECT vend_name FROM Vendors WHERE vend_country = 'USA' AND &n...

Mysql

2022-03-05

6 1101

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

SELECT DISTINCT order_num FROM OrderItems WHERE quantity >= ...

Mysql

2022-03-05

35 3730

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

SELECT prod_name, prod_price FROM Products WHERE prod_...

Mysql

2022-03-05

15 1480

题解 | #返回更高价格的产品#

SELECT prod_id, prod_name FROM Products WHERE prod_pri...

Mysql

2022-03-05

9 1070

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

SELECT prod_id, prod_name FROM Products WHERE prod_pri...

Mysql

2022-03-04

9 1114

题解 | #检查SQL语句#

SELECT vend_name FROM Vendors ORDER BY vend_name&...

Mysql

2022-03-04

9 1179