text: -- lists all genres from hbtn_0d_tvshows and displays the number of shows linked to each
  SELECT a.name AS genre, COUNT(b.genre_id) AS number_of_shows
  FROM tv_genres a
  JOIN tv_show_genres b
  ON a.id = b.genre_id
  GROUP BY b.genre_id
  ORDER BY number_of_shows DESC;
  