学习生1

分类

/ 注册

全部文章（共175篇）

题解 | #返回购买价格为 10 美元或以上产品的顾客列表#

select cust_id from Orders left join OrderItems on OrderItems.order_num = Orders.order_num where OrderItems.item_price >= 10;

2024-11-26

0 42

题解 | #返回每个订单号各有多少行数#

select order_num, count(order_num) as order_lines from OrderItems group by order_num order by order_lines;

2024-11-26

0 52

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

select sum(quantity) as items_ordered from OrderItems; #sum()求和

2024-11-25

0 71

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

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

2024-11-25

0 85

题解 | #顾客登录名#

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

2024-11-25

0 64

题解 | #打折#

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

2024-11-25

0 63

题解 | #别名#

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

2024-11-25

0 62

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

select *from Products where prod_desc like '%toy%carrots%';

2024-11-25

0 90

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

select * from Products where prod_desc like '%toy%' and prod_desc like '%carrots%';

2024-11-25

0 66

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

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

2024-11-25

0 54