s03t09e03

SELECT billing_country AS country,
        COUNT(billing_postal_code IS NULL) AS miss
FROM invoice
WHERE billing_address NOT LIKE '%Street%'
        AND billing_address NOT LIKE '%Way%'
        AND billing_address NOT LIKE '%Road%'
        AND billing_address NOT LIKE '%Drive%'
GROUP BY billing_country
HAVING COUNT(billing_postal_code IS NULL) > 10;