| select time_by_day.the_year as c0, store.store_state as c1, FACT.warehouse_id as c2, 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 FACT.store_id = store.store_id and store.store_state = 'WA' and FACT.warehouse_id = 2 group by time_by_day.the_year, store.store_state, FACT.warehouse_id; |