нужно было использовать оператор MAX:

SELECT billing_city
FROM invoice
WHERE total >
    (SELECT MAX(total)
     FROM invoice
     WHERE EXTRACT(YEAR FROM CAST(invoice_date AS DATE)) = 2009)
GROUP BY billing_city;