- SELECT
- DISTINCT(last_name)
- FROM client as c
- LEFT OUTER JOIN
- (SELECT customer_id
- FROM invoice
- WHERE EXTRACT(YEAR FROM CAST(invoice_date AS timestamp))=2013
- AND EXTRACT(MONTH FROM CAST(invoice_date AS timestamp))<>1
- AND customer_id IN
- (SELECT
- customer_id
- FROM invoice
- WHERE EXTRACT(YEAR FROM CAST(invoice_date AS timestamp))=2013
- AND EXTRACT(MONTH FROM CAST(invoice_date AS timestamp))=1
- GROUP BY customer_id
- HAVING COUNT(invoice_id)<>0)
- GROUP BY customer_id
- HAVING COUNT(invoice_id)<>0) AS i_i ON i_i.customer_id=c.customer_id
- WHERE c.customer_id IS NOT NULL;