, Tom Lane wrote:
> Rob Sargent writes:
> > On 04/13/2011 09:09 AM, Tom Lane wrote:
> >> Anish Kejariwal writes:
> >>> (select store_id, avg(sales) sales
> >>> from store
> >>> where group_id in(select $1[i] from generate_subscripts($1, 1) g
I have the following query:
select seta.store_id, avg(seta.sales) avg_seta, avg(setb.sales) avg_setb
from
(select store_id, avg(sales) sales
from store where group_id in(10,11,12)
group by store_id
) seta,
(select store_id, avg(sales) sales
from store where group_id in(13,14,15)
group by
