blob: da865f78267b27ea985a3dd9a3f5256c479ad872 [file] [log] [blame]
select storea.store_country as c0, storeb.store_country as c1, sum(inventory_fact_1997.supply_time) as m0 from store as storea, inventory_fact_1997 as inventory_fact_1997, store as storeb where inventory_fact_1997.store_id = storea.store_id and storea.store_country = 'USA' and inventory_fact_1997.warehouse_id = storeb.store_id and storeb.store_country = 'USA' group by storea.store_country, storeb.store_country;