I copied and pasted that SQL statment and only changed table and column names and it works.
What version of mySQL are you running? What is the data type of creationDate adn amountFound? do either allow null? Do you get the error when you remove the SUM(amountFound) line?