【SQL】sqlzoo练习题Music Tutorial

原地址：https://sqlzoo.net/wiki/Music_Tutorial/zh

上一篇：sqlzoo练习题The JOIN operation

1.找出收錄歌曲song 'Alison’的碟名title和歌手artist。.

select title,artist from album join track on album.asin = track.album
 where song = 'Alison'

2.哪一歌手artist 錄了歌曲 song ‘Exodus’?

select artist from album join track on album.asin = track.album
 where song = 'Exodus'

3.顯示album 'Blur’的每一首歌的歌名 song 。

select song from track