1 题目 可回收且低脂的产品
# 题解如下: select product_id from products where low_fats = 'Y' and recyclable = 'Y'
2 题目 寻找用户推荐人
# 对于此题主要就是对于null的判断
# 解题思路1
select name
from customer
# 使用安全等于,来解决问题
where not referee_id <=> 2
# 解题思路2
SELECT name
FROM customer
WHERE referee_id <> 2 OR referee_id IS NULL;
# 解题思路3
SELECT name
FROM customer
WHERE referee_id != 2 OR referee_id IS NULL;