Merhaba..

Bu sorguyu dener misiniz?

select cost, SID,PID
from catalog as trz
where cost>(select avg(cost) from catalog where PID=trz.PID)