- SELECT DISTINCT EXTRACT(YEAR FROM CAST(i.invoice_date AS date)) AS year_of_invoice,
- COUNT(t.name)
- FROM invoice AS i
- LEFT OUTER JOIN invoice_line AS il ON i.invoice_id = il.invoice_id
- LEFT OUTER JOIN track AS t ON il.track_id = t.track_id
- GROUP BY year_of_invoice;
Re: Untitled
From Little Human, 10 Months ago, written in Plain Text, viewed 304 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
— Expand Paste to full width of browser