Untitled

SELECT
  artists.name AS "Artista"
FROM
  artists
JOIN artists_followers ON artists.id = artists_followers.artist_id
GROUP BY
  artists.name
ORDER BY
  COUNT(artists_followers.artist_id) DESC
LIMIT 1;