阿莉勒丝黛拉

分类

题解(169)

/ 注册

全部文章（共128篇）

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

SELECT MAX(prod_price) max_price FROM Products WHERE prod_price&nbs...

Mysql

2022-03-05

2 862

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

SELECT SUM(quantity) items_ordered FROM OrderItems WHERE prod_id&nb...

Mysql

2022-03-05

3 875

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

SELECT SUM(quantity) items_ordered FROM OrderItems;

Mysql

2022-03-05

17 1454

题解 | #返回 2020 年 1 月的所有订单的订单号和订单日期#

SELECT order_num, order_date FROM Orders WHERE YEAR(or...

Mysql

2022-03-05

2 632

题解 | #顾客登录名#

SELECT cust_id, cust_name, UPPER(CONCAT(SUBSTRING(cust_contact, 1, 2), SUBSTRING(cust_city, 1, 3))) us...

Mysql

2022-03-05

2 730

题解 | #打折#

SELECT prod_id, prod_price, prod_price * 0.9 sale_price FROM Products;

Mysql

2022-03-05

11 1407

题解 | #别名#

SELECT vend_id, vend_name AS vname, vend_address AS vaddress, vend_city AS vcity FROM &n...

Mysql

2022-03-05

1 953

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

SELECT prod_name, prod_desc FROM Products WHERE prod_d...

Mysql

2022-03-05

4 860

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

SELECT prod_name, prod_desc FROM Products WHERE prod_d...

Mysql

2022-03-05

5 918

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

SELECT prod_name, prod_desc FROM Products WHERE prod_desc NOT LIKE '%toy%' ORDER BY prod_name;

Mysql

2022-03-05

5 1461