Untitled

From Insensitive Bird, 8 Months ago, written in Plain Text, viewed 183 times.

URL http://codebin.org/view/569c0428 Embed

Download Paste or View Raw

SELECT g.name,
            COUNT(t.track_id)
FROM track AS t
INNER JOIN invoice_line AS il ON t.track_id=il.track_id
INNER JOIN invoice AS i ON i.invoice_id=il.invoice_id
INNER JOIN track ON t.track_id = il.track_id
INNER JOIN genre AS g ON t.genre_id = g.genre_id
 
 
GROUP BY g.name -- добавьте поле для группировки
ORDER BY COUNT(t.track_id) DESC

Replies to Untitled

Title	Name	Language	When
Re: Untitled	Smelly Finch	text	8 Months ago.

Reply to "Untitled"

Here you can reply to the paste above

Author What's your name?

Title Give your paste a title.

Language What language is your paste written in?

Your paste Paste your paste here

Create Shorturl Create a shorter url that redirects to your paste?

Private Private paste aren't shown in recent listings.

Delete After When should we delete your paste?