Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Code examples for SQL 1x1 blog-article - 15
SELECT
InvoiceId,
c.Name as Genre,
count(a.TrackId) AS AnzahlProKauf
FROM InvoiceLine a
INNER JOIN Track b on a.TrackId=b.TrackId
LEFT JOIN Genre c on b.GenreId=c.GenreId
GROUP BY InvoiceId, b.GenreId;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment