I m trying to find the number of rows which contain a value greater than 7 and less than 13.99. However, the following query always returns 0, and that s just not possible.
任何人能否在我的询问中看到问题?
SELECT COUNT(*) FROM lead_status AS ls
INNER JOIN leads AS l ON l.id = ls.lead_id
INNER JOIN contacts AS c ON c.lead_id = l.id
WHERE ls.discriminator = AUTO_POST AND l.affiliate_id=1003
AND ls.winner =1 AND l.test =0 AND l.create_date BETWEEN 2011-10-03 AND 2011-10-17
AND ls.amount >= 7 AND ls.amount <= 13.99;