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 Embed
Download Paste or View Raw
  1. SELECT DISTINCT AS genre_name,
  2. COUNT(i.invoice_id) AS all_count
  3. FROM invoice_line AS i
  4. INNER JOIN track as t ON t.track_id=i.track_id
  5. INNER JOIN genre AS g ON g.genre_id = t.genre_id
  6. GROUP BY genre_name
  7. ORDER BY all_count DESC

Reply to "Re: Re: Re: Re: Re: Untitled"

Here you can reply to the paste above