sql刷题

刷的是力扣的热门，从简单开始刷

题库 - 力扣 (LeetCode) 全球极客挚爱的技术成长平台

 

# Write your MySQL query statement below
select name,bonus
from Employee e
left join Bonus b on e.empId=b.empId
where b.bonus<1000 or b.bonus is null
# where ifnull(b.bonus,0)<1000

584. 寻找用户推荐人:力扣

# Write your MySQL query statement below
select name
from customer
where ifnull(referee_id,0) <>2

这道题的考察点在于，sql里面的不等于，不包含null。