Re: Re: Re: Re: Untitled

From Corrupt Meerkat, 4 Months ago, written in Plain Text, viewed 97 times. This paste is a reply to Re: Re: Re: Untitled from Emerald Lechwe - view diff
URL Embed
Download Paste or View Raw
  1. SELECT AS playlist_name,
  2.        SUM(t.unit_price) AS total_revenue
  4. -- укажите нужные поля
  5. FROM track AS t
  6. INNER JOIN invoice_line AS i ON t.track_id=i.track_id
  7. INNER JOIN playlist_track AS pl ON t.track_id=pl.track_id
  8. INNER JOIN playlist AS p ON pl.playlist_id = p.playlist_id
  9. GROUP BY playlist_name-- добавьте поле для группировки
  10. ORDER BY SUM(t.unit_price) DESC -- добавьте поле для сортировки;

Replies to Re: Re: Re: Re: Untitled rss

Title Name Language When
Re: Re: Re: Re: Re: Untitled Morose Octupus text 4 Months ago.

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

Here you can reply to the paste above