本笔记为阿里云天池龙珠训练SQL训练营的学习内容链接为“https://tianchi.aliyun.com/forum/postDetail?spm=5176.20222307.J_9059755”

task02的学习笔记如下

练习题1

代码

select product_name,regist_date

from product

where regist_date > '2009-04-28'

练习题2

①

SELECT *
  FROM product
 WHERE purchase_price = NULL;

在表为product中筛选出purchase_price列里面值为NULL的其他行。

②

SELECT *
  FROM product
 WHERE purchase_price <> NULL;

在表为product中选出purchase_price列里面查找值非NULL的其他行。

③

SELECT *
  FROM product
 WHERE product_name > NULL;

在表为product中查找product_name列里面不为NULL的列。

练习题3

①

select product_name,sale_price,purchase_prise

from product

where (sale_price - purchase_prise) >=500

②

select product_name,sale_price,purchase_price

from product

where not in (sale_price - purchase_price) < 500

练习题4

select product_id,product_type '利润'

from product

where (sale_price*0.9 - purchase_price) > 100

 练习题5

1.第一行SUM应当是对数值列进行求和，product_name为字节型

2.group by 后面的内容错误，应当和select之后的内容一致

3.group by 写在了where的前面，应该写在where的后面

练习题6

select product_type,sum(sale_price),sum,sum(purchase_price) sum

from product

group by product_type,sum(sale_price),sum,sum(purchase_price)

having sum(sale_price)>sum(purchase_price)*1.5

联系题7

select *

from product

order by regist_date desc