lizhenzhen

分类

/ 注册

全部文章（共65篇）

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

select order_num, order_date from Orders where left(order_date,7)='2020-01' order by order_date;

2025-12-29

0 25

题解 | 顾客登录名

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

2025-12-29

0 28

题解 | 打折

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

2025-12-29

0 21

题解 | 别名

select vend_id, vend_name as vname, vend_address as vaddress, vend_city as vcity from Vendors order by vname;

2025-12-29

0 25

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

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

2025-12-29

0 29

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

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

2025-12-29

0 22

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

select prod_name,prod_desc from Products where prod_desc not like '%toy%' order by prod_name;

2025-12-29

0 21

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

select order_num,prod_id,quantity from OrderItems where prod_id in ('BR01','BR02','BR03') and quantity>=100;

2025-12-29

0 21

题解 | 贷款情况

with t1 as -- 统计每个城市的总贷款金额/平均每位客户的贷款金额/客户总数 (select city, round(sum(loan_amount),2) as total_loan_amount, round(sum(loan_amount)/count(di...

2025-12-22

0 26

题解 | 最受欢迎的top3课程

select c.cid, count(uid) as pv, sum(timestampdiff(minute,start_time,end_time)) as time_len from course_info_tb as c join play_record_t...

2025-12-21

0 19