CREATE TABLE artists ( id SERIAL PRIMARY KEY, name TEXT, genres jsonb );

INSERT INTO artists(name, genres) VALUES ('Kraftwerk', '["electronic"]'), ('Daft Punk', '["electronic", "house"]'), ('Maroon 5', '["pop", "rock"]'), ('One Republic', '["pop", "rock"]'), ('Lil Nas X', '["hip-hop", "country rap", "rap"]'), ('Post Malone', '["hip-hop", "rap", "trap"]'), ('Drake', '["hip-hop", "rap"]');

SELECT * FROM artists;

SELECT jsonb_array_elements(artists.genres) AS genre FROM artists;

SELECT jsonb_array_elements(a.genres) AS genre, COUNT(1) AS popularity FROM artists AS a GROUP BY genre ORDER BY popularity DESC;