select "products".productline AS "products_line", SUM("orderfact".totalprice) AS "orderfact_totalprice", SUM("orderfact".quantityordered) AS "orderfact_quantityordered" from PUBLIC.orderfact "orderfact", PUBLIC.products "products", PUBLIC.timeline "timeline" where "orderfact".productcode="products".productcode AND "orderfact".time_id="timeline".id AND "timeline".year_nb=2008 group by "products".productline order by "products_line", "orderfact_totalprice", "orderfact_quantityordered"