| select customer.country as c0, store.store_sqft as c1 from customer as customer, sales_fact_1997 as sales_fact_1997, store as store where sales_fact_1997.customer_id = customer.customer_id and sales_fact_1997.store_id = store.store_id and (customer.country = 'USA') and (not ((store.store_sqft = 39696 or store.store_sqft is null))) group by customer.country, store.store_sqft order by customer.country ASC NULLS LAST, store.store_sqft ASC NULLS LAST; |