GB279824

分类

/ 注册

全部文章（共162篇）

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

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

2025-05-20

0 20

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

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

2025-05-20

0 11

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

select sum(quantity) as items_ordered from OrderItems;

2025-05-20

0 16

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

select order_num,order_date from Orders where year(order_date) = 2020 and month(order_date) = 1 order by order_date ASC;

2025-05-20

0 19

题解 | 顾客登录名

select cust_id, cust_name, upper(concat(substring(cust_contact,1,2),substring(cust_city,1,3))) as user_login from Customers;

2025-05-20

0 18

题解 | 打折

select prod_id, prod_price, (0.9 * prod_price) as sale_price from Products;

2025-05-20

0 20

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

select prod_name,prod_desc from Products where prod_desc like '%toy%carrots%';

2025-05-20

0 17

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

select prod_name,prod_desc from Products where prod_desc like "%toy%" and prod_desc like "%carrots%";

2025-05-20

0 18

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

select prod_name,prod_desc from Products where prod_desc not like "%toy%"

2025-05-20

0 14

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

select distinct(prod_id) as prod_id from OrderItems

2025-05-19

0 19