desafio5.sql

SELECT
  s.song_name AS cancao,
  COUNT(pl.song_id) AS reproducoes
FROM
  SpotifyClone.songs AS s
  INNER JOIN SpotifyClone.plays_history AS pl ON pl.song_id = s.song_id
GROUP BY
  s.song_name
ORDER BY
  reproducoes DESC,
  cancao
LIMIT
  2;