blob: bcdf823f73983436daa350b03d1fbb7a0c665b8a [file] [log] [blame]
select store.store_state as c0, sum(store.store_sqft) as m0, sum(store.grocery_sqft) as m1, count(*) as m2 from store as store where store.store_state = 'CA' group by store.store_state;