人生苦短，但求成长

分类

题解(166)

/ 注册

全部文章（共150篇）

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

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

Mysql

2022-03-12

3 0

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

select order_num,order_date from Orders where month(order_date) = 1 and year(order_date) = 2020 ord...

Mysql

2022-03-12

15 430

题解 | #顾客登录名#

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

Mysql

2022-03-12

3 637

题解 | #打折#

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

Mysql

2022-03-12

2 505

题解 | #别名#

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

Mysql

2022-03-12

4 549

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

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

Mysql

2022-03-12

12 850

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

select prod_name, prod_desc from Products where prod_desc like '%toy%' a...

Mysql

2022-03-12

3 536

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

select prod_name, prod_desc from Products where prod_desc not like '%toy...

Mysql

2022-03-12

2 473

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

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

Mysql

2022-03-12

40 1434

题解 | #纠错2#

SELECT vend_name FROM Vendors WHERE vend_country = 'USA' AND vend_state = 'CA' ORDER BY&...

Mysql

2022-03-12

2 418