Why does this query fail?

SELECT SUM(amount) AS total

FROM orders

WHERE total > 100