Query: imdb_moview_earnings_by_genre

select 
  g.genre,
  sum(e.Worldwide) as "Total Earnings"
from
  genre g
  join earning e on g.Movie_id = e.Movie_id
group by
  g.genre
order by
  "Total Earnings" desc;