select t.pname,t.pprice from (select * from product) as t select pname,pprice from product where pprice In(select avg(pprice) from product group by pname) select avg ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results