How many posts were created on 21st July, 2010?
created on 21st July, 2010 refers to CreationDate BETWEEN '2010-07-21 00:00:00' and '2012-07-21 23:59:59';
SELECT COUNT(id) FROM postHistory WHERE date(CreationDate) = '2010-07-21'