Re: Re: Re: Re: Re: Untitled

From Morose Octupus, 4 Months ago, written in Plain Text, viewed 79 times. This paste is a reply to Re: Re: Re: Re: Untitled from Corrupt Meerkat - view diff

URL http://codebin.org/view/f0f54112 Embed

Download Paste or View Raw

SELECT DISTINCT g.name AS genre_name,
COUNT(i.invoice_id) AS all_count
FROM invoice_line AS i
INNER JOIN track as t ON t.track_id=i.track_id
INNER JOIN genre AS g ON g.genre_id = t.genre_id
GROUP BY genre_name
ORDER BY all_count DESC

Reply to "Re: Re: Re: Re: Re: 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?