逻辑运算符

/*
逻辑运算符
与：&& 或 and
或：|| 或 or
非：! 或 not

*/
#查询薪资高于10000 并且低于15000的女员工
SELECT * FROM t_employee
WHERE salary > 10000 && salary <15000 AND gender = ‘女’

#查询薪资高于20000 或者 籍贯是 浙江
SELECT * FROM t_employee
WHERE salary > 20000 || native_place = ‘浙江’;

#查询非浙江籍的男生
SELECT * FROM t_employee
WHERE NOT native_place = ‘浙江’ AND gender = ‘男’;

#查询奖金比例非空的员工
SELECT * FROM t_employee
WHERE commission_pct IS NOT NULL;