NOT EXISTS for missing rows

Common Use Cases Which query correctly finds customers with no open tickets?