select b.title, b.isbn, b.description, b.author from book AS b  
INNER JOIN book_genre AS bg on b.book_id=bg.book_id 
INNER JOIN genre AS g where g.name = 'comedy';

CREATE TABLE `genre` (
  `genre_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) NOT NULL,
  UNIQUE KEY `name_UNIQUE` (`name`),
  PRIMARY KEY (`genre_id`)
);

CREATE TABLE `book` (
  `book_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(70) NOT NULL,
  `isbn` int (11) NOT NULL,
  `author` varchar(70) NOT NULL,
  `description` varchar(250) NOT NULL,
  PRIMARY KEY (`book_id`)
);

CREATE TABLE `book_genre` (
  `book_id` int(11) NOT NULL,
  `genre_id` int(11) NOT NULL,
  PRIMARY KEY (`book_id`,`genre_id`),
  UNIQUE KEY `book_id_UNIQUE` (`book_id`),
  KEY `fk_book` (`genre_id`),
  KEY `fk_genre` (`book_id`),
  CONSTRAINT `fk_book` FOREIGN KEY (`book_id`) REFERENCES `book` (`book_id`),
  CONSTRAINT `fk_genre` FOREIGN KEY (`genre_id`) REFERENCES `genre` (`genre_id`)
);

select title, isbn, description, author 
from book 
natural join book_genre 
natural join genre where name = 'comedy';