SQLZOO: Music Tutorial/zh

9. 好價大碟是指大碟中每一首歌曲的價格是少於5角。 找出好價大碟，列出大碟名字，售價和歌曲數量。

select title,price,count(song)
FROM album a JOIN track aa ON (a.asin=aa.album)
where 0.5>all(select price/count(song) from album b JOIN track bb ON (b.asin=bb.album) where a.asin=b.asin group by price)
group by title,price

10. 歌手Wagner的大碟 Ring cycle 有173首歌曲, 歌手Bing Crosby有一大碟 收錄了 101首歌曲

select title,count(song)as num
from album a JOIN track aa ON (a.asin=aa.album)
group by title
order by num desc