I'm using this statement on the wonderful DB2 (on an AS400 ) and it says that the calculated expression is invalid so what's the correct way to write this:

select order_num, SUM(num_ordered) * quoted_price as order_total
from order_line order by order_num

I tried it with parenthesis around the whole thing and without the as statement and neither way worked either