- SELECT c.last_name
- FROM client AS c
- LEFT OUTER JOIN invoice AS i ON c.customer_id = i.customer_id
- WHERE c.customer_id IN (SELECT i.customer_id
- FROM invoice
- WHERE CAST (invoice_date AS date) BETWEEN '2013-01-01' AND '2013-01-31'
- AND EXTRACT (YEAR FROM CAST (invoice_date AS date)) = 2013
- AND CAST (invoice_date AS date) BETWEEN '2013-02-01' AND '2013-12-31' )