--7. Select distinct names and descriptions of clubs which offer books purchased at the most expensive price available for a particular title

select distinct c.club, c.desc 
from yrb_club c, yrb_purchase p, yrb_offer o 
where c.club = p.club and o.title = p.title 
	and o.year = p.year and o.title = p.title 
	and o.price = 
			(select max (oo.price) 
			from yrb_offer oo 
			where oo.title = o.title and oo.year = o.year)
