select "customers".city AS "customers_city", SUM(ROUND(orderfact.totalprice/1000,1)) AS "orderfact_totalprice/1000" from PUBLIC.customers "customers", PUBLIC.timeline "timeline", PUBLIC.orderfact "orderfact" where "orderfact".customernumber="customers".customernumber AND "orderfact".time_id="timeline".id AND "timeline".id>='2014-01-01' AND "timeline".id<='2015-01-01' group by "customers".city order by "customers_city"