Question #6

[orick14]

Solution query doesn't give any result for me. I changed between primary keys doesn't help. Help please

[bazhdarrzgar]

SELECT bands.name AS 'Band Name' FROM bands LEFT JOIN albums ON bands.id = albums.band_id GROUP BY bands.id HAVING COUNT(albums.band_id) = 0;

this is work for me

[arthur-debiasi]

SELECT bands.name AS 'Band Name' FROM bands LEFT JOIN albums ON bands.id = albums.band_id GROUP BY bands.id HAVING COUNT(albums.band_id) = 0;

this works for me either