Erro de SQL

[barisonalisson]

Falta adicionar uma condição ao INNER JOIN para o filtro ficar correto
-- caracterizando os registros dos artistas
SELECT a2.ArtistId, a2.Name, count() as Records from Album a INNER JOIN Artist a2 ON a2.ArtistId=a.ArtistId GROUP BY 1;
SELECT a2.ArtistId, a2.Name, count() as Records from Album a INNER JOIN Artist a2 ON a2.ArtistId=a.ArtistId GROUP BY 1 ORDER BY Records DESC ;

O mesmo na sql:
SELECT i.InvoiceId, il.InvoiceLineId FROM Invoice i
INNER JOIN InvoiceLine il ON il.InvoiceId = i.InvoiceId
INNER JOIN Customer c ON c.CustomerId = i.CustomerId
GROUP BY 1
LIMIT 100;