select "products".productline AS "products_line", SUM("orderfact".quantityordered) AS "orderfact_quantityordered" from customers "customers", orderfact "orderfact", products "products" where "orderfact".customernumber="customers".customernumber AND "orderfact".productcode="products".productcode AND "customers".country='Canada' group by "products".productline order by "products_line", "orderfact_quantityordered"