Re: Untitled

From Little Human, 9 Months ago, written in Plain Text, viewed 261 times. This paste is a reply to Untitled from Edgy Crane - view diff
URL http://codebin.org/view/9678d45e Embed
Download Paste or View Raw
  1. SELECT DISTINCT EXTRACT(YEAR FROM CAST(i.invoice_date AS date)) AS year_of_invoice,
  2.         COUNT(t.name)
  3.       FROM invoice AS i
  4. LEFT OUTER JOIN invoice_line AS il ON i.invoice_id = il.invoice_id
  5. LEFT OUTER JOIN track AS t ON il.track_id = t.track_id
  6. GROUP BY year_of_invoice;

Replies to Re: Untitled rss

Title Name Language When
Re: Re: Untitled Eratic Panda text 6 Days ago.
Re: Re: Untitled Social Lizard text 9 Months ago.

Reply to "Re: Untitled"

Here you can reply to the paste above