| select time_by_day.the_year as c0, time_by_day.quarter as c1, store.store_state as c2, FACT.warehouse_id as c3, sum(FACT.warehouse_cost) as m0 from time_by_day as time_by_day, (select * from inventory_fact_1997 as FOOBAR) as FACT, store as store where FACT.time_id = time_by_day.time_id and time_by_day.the_year = 1997 and time_by_day.quarter = 'Q3' and FACT.store_id = store.store_id and store.store_state = 'WA' and FACT.warehouse_id = 2 group by time_by_day.the_year, time_by_day.quarter, store.store_state, FACT.warehouse_id; |