MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table tv_shows (
  id int,
  title varchar(266),
  channel varchar(266)
);
create table tv_genres (
  id int,
  name varchar(266)
);
create table tv_show_genres (
  id int,
  show_id int,
  genre_id int
);
insert into tv_shows values
(1, 'First title', 'NBC'),
(2, 'Second title', 'SomeTVShowChannel'),
(3, 'Some title', 'NBC'),
(4, 'Funny title', 'NBC'),
(5, 'Funny title', 'NBC2');
insert into tv_genres values
(1, 'Comedy'),
(2, 'Detective');
insert into tv_show_genres values
(1, 1, 1),
(2, 2, 2),
(3, 3, 2),
(4, 4, 1),
(5, 5, 2);

Records: 5  Duplicates: 0  Warnings: 0



Records: 2  Duplicates: 0  Warnings: 0



Records: 5  Duplicates: 0  Warnings: 0


SELECT DISTINCT `title`
  FROM `tv_shows` AS t
       LEFT JOIN `tv_show_genres` AS s ON s.`show_id` = t.`id`
       LEFT JOIN `tv_genres` AS g ON g.`id` = s.`genre_id`
       WHERE t.`title` NOT IN
             (SELECT `title`
              FROM   `tv_shows` AS t
                     INNER JOIN `tv_show_genres` AS s ON s.`show_id` = t.`id`
                     INNER JOIN `tv_genres` AS g ON g.`id` = s.`genre_id`
              WHERE g.`name` = "Comedy")
 ORDER BY `title`;


title


Second title

Some title


SELECT DISTINCT `title`
      FROM `tv_shows` AS t
           LEFT JOIN `tv_show_genres` AS s ON s.`show_id` = t.`id`
           LEFT JOIN `tv_genres` AS g ON g.`id` = s.`genre_id`
      WHERE g.`name` != "Comedy";


title


Second title

Some title

Funny title