Nick

icon location London, UK icon location 2021 Graduate from MSc Statistics, UCL

Results 2 comments of Nick

MySQL

> SELECT bands.name AS 'Band Name' FROM bands LEFT JOIN albums ON bands.id = albums.band_id GROUP BY bands.id having count(albums.id) =0; > > In the last line instead of albums.id...

Updating a query that didn't work.

The solution for exercise 5 didn't work for me either and the error was returned as follow: Error Code: 1055. Expression #1 of SELECT list is not in GROUP BY...