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