Untitled

From Kotya, 2 Months ago, written in Plain Text, viewed 104 times.
URL http://codebin.org/view/81fff9ac Embed
Download Paste or View Raw
  1. SELECT
  2. DISTINCT(last_name)
  3. FROM client as c
  4. LEFT OUTER JOIN
  5. (SELECT customer_id
  6. FROM invoice
  7. WHERE EXTRACT(YEAR FROM CAST(invoice_date AS timestamp))=2013
  8. AND EXTRACT(MONTH FROM CAST(invoice_date AS timestamp))<>1
  9. AND customer_id IN
  10. (SELECT
  11. customer_id
  12. FROM invoice
  13. WHERE EXTRACT(YEAR FROM CAST(invoice_date AS timestamp))=2013
  14. AND EXTRACT(MONTH FROM CAST(invoice_date AS timestamp))=1
  15. GROUP  BY customer_id
  16. HAVING COUNT(invoice_id)<>0)
  17. GROUP  BY customer_id
  18. HAVING COUNT(invoice_id)<>0) AS i_i ON i_i.customer_id=c.customer_id
  19. WHERE c.customer_id IS NOT NULL;

Reply to "Untitled"

Here you can reply to the paste above