sample-one

column "Movie" format a30;

select distinct tm.MovieTitle as "Movie"
from tblKeyword tk
	inner join (tblKeywordDetail tkd 
		inner join tblMovie tm on tm.MovieID = tkd.MovieID )
	on tkd.KeywordID = tk.KeywordID
where tk.KeywordDesc Like '%France%' OR 
	  tk.KeywordDesc Like '%Pizza%' OR 
	  tk.KeywordDesc Like '%Waitress%'
Order by tm.MovieTitle;


/*

Movie
------------------------------
30 Minutes or Less
Drive Angry
Saving Private Ryan
Taken


*/