GB279824

分类

/ 注册

全部文章（共190篇）

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

select sum(quantity) as items_ordered from OrderItems;

2025-05-20

0 38

题解 | 返回 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 40

题解 | 顾客登录名

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 34

题解 | 打折

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

2025-05-20

0 36

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

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

2025-05-20

0 35

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

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

2025-05-20

0 36

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

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

2025-05-20

0 34

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

select distinct(prod_id) as prod_id from OrderItems

2025-05-19

0 30

题解 | 每个月Top3的周杰伦歌曲

select * from( select month(p.fdate) as month, row_number() over(partition by month(fdate) order by count(s.song_id) DESC, ...

2025-05-17

0 40

题解 | 浙大不同难度题目的正确率

select qd.difficult_level, round(AVG(if(q.result = 'right',1,0)),4) as correct_rate from user_profile u join question_practice_detail q o...

2025-05-17

0 38