select p.name, b. category, avg(b.retail)
from books b, publisher p
where b.pubid = p.pubid
and b.category in ('CHILDREN','COMPUTER')
group by p.name, b.category;