select "products".productline AS "products_line", "products".productname AS "products_name", "products".productscale AS "products_scale", "products".productdescription AS "products_description", SUM("orderfact".quantityordered) AS "orderfact_quantityordered" from PUBLIC.orderfact "orderfact", PUBLIC.products "products" where "orderfact".productcode="products".productcode group by "products".productline, "products".productname, "products".productscale, "products".productdescription order by "products_line", "products_name", "products_scale", "products_description", "orderfact_quantityordered"