阿莉勒丝黛拉

题解

/ 注册

全部文章 / 题解（共162篇）

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

SELECT prod_name, prod_desc FROM Products WHERE prod_d...

Mysql

2022-03-05

1 936

题解 | #纠错2#

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

Mysql

2022-03-05

1 648

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

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

Mysql

2022-03-05

18 1007

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

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

Mysql

2022-03-05

39 2372

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

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

Mysql

2022-03-05

6 1098

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

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

Mysql

2022-03-05

35 3728

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

SELECT prod_name, prod_price FROM Products WHERE prod_...

Mysql

2022-03-05

15 1477

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

SELECT prod_id, prod_name FROM Products WHERE prod_pri...

Mysql

2022-03-05

9 1067

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

SELECT prod_id, prod_name FROM Products WHERE prod_pri...

Mysql

2022-03-04

9 1113

题解 | #检查SQL语句#

SELECT vend_name FROM Vendors ORDER BY vend_name&...

Mysql

2022-03-04

9 1175