Untitled

mail@pastecode.io avatar
unknown
plain_text
7 months ago
293 B
2
Indexable
Never

SELECT artists.name AS "Artista",
COUNT(artists_followers.artist_id) AS "Total de seguidores"
FROM artists
JOIN artists_followers
ON artists.id = artists_followers.artist_id
GROUP BY artists.name
HAVING COUNT(artists_followers.artist_id) < 5
ORDER BY COUNT(artists_followers.artist_id) DESC;
Leave a Comment