<filename>0x0E-SQL_more_queries/101-not_a_comedy.sql
-- lists all shows without the genre Comedy in the database btcp_0d_tvshows
SELECT tv_shows.title FROM tv_shows
	   WHERE tv_shows.id NOT IN
	   (SELECT tv_shows.id FROM tv_shows
	   		   INNER JOIN tv_show_genres
			   ON tv_shows.id = tv_show_genres.show_id
			   INNER JOIN tv_genres
			   ON tv_genres.id = tv_show_genres.genre_id
			   WHERE tv_genres.name = 'Comedy')
		ORDER BY tv_shows.title ASC;
