MySQL为什么IS NOT NULL 和 BETWEEN不能在一起使用？

Question

第一种情况IS NOT NULL BETWEEN 接连使用为什么不可以，会报错？
SELECT
*
FROM
contract c
LEFT JOIN apply a ON c.apply_id = a.apply_id
WHERE
a.is_ex_apply = '1'
AND c.actual_loan_time IS NOT NULL BETWEEN 0
AND 100;
第二种情况就可以：
SELECT
*
FROM
contract c
LEFT JOIN apply a ON c.apply_id = a.apply_id
WHERE
c.actual_loan_time IS NOT NULL
AND a.is_ex_apply = '1' BETWEEN 0
AND 100;

Answer 1

第一种指的是c.actual_loan_time IS NOT NULL在0到100