blob: 5c4357c9523bebcdd05310cdbf4f20f2bf7edf56 [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.store_id = storeb.store_id and storeb.store_country = 'USA' group by storea.store_country, storeb.store_country;