SELECT sum(dbo.titles.advance),avg(dbo.titles.price), dbo.publishers.pub_name
FROM dbo.titles INNER JOIN
dbo.publishers ON dbo.titles.pub_id = dbo.publishers.pub_id
group by dbo.publishers.pub_name
having sum(dbo.titles.advance)>$2500 and avg(dbo.titles.price)>$15
FROM dbo.titles INNER JOIN
dbo.publishers ON dbo.titles.pub_id = dbo.publishers.pub_id
group by dbo.publishers.pub_name
having sum(dbo.titles.advance)>$2500 and avg(dbo.titles.price)>$15
,avg(dbo.titles.price) as avgprice, dbo.publishers.pub_name
FROM dbo.titles INNER JOIN
dbo.publishers ON dbo.titles.pub_id = dbo.publishers.pub_id
group by dbo.publishers.pub_name
having sum(dbo.titles.advance)>$2500 and avg(dbo.titles.price)>$15