select "products".productname AS "products_name", SUM(ROUND(orderfact.totalprice/1000,1)) AS "orderfact_totalprice" from PUBLIC.orderfact "orderfact", PUBLIC.products "products", PUBLIC.timeline "timeline" where "orderfact".productcode="products".productcode AND "orderfact".time_id="timeline".id AND "timeline".id>='2008-01-01' AND "timeline".id<='2009-01-01' group by "products".productname order by "products_name"