WITHyearly AS SELECT customer_id YEARorder_date AS order_year SUMprice AS yearly_amount FROM Orders GROUP BY customer_id YEARorder_date ORDER BY 1 2 consecutive AS

The SQL query seems to be correct syntactically. However, it is possible that there is an error in the database schema or data that is causing unexpected results.