kon

```
id | name
1    alex
2    peter
3    john

```

ticket

```
id  | amount | kon_id | package
122   13        1        234
123   12        1        234
124   20        2        NULL
125   23        2        235
126   19        1        236

```

I would like to get a list of all contacts with the sum of the amount, except tickets, where the package entry is NULL.
My problem is, that I only get the contacts which have a ticket, because of the WHERE clause. 

```
SELECT 
    kon.id, 
    kon.name, 
    SUM(ticket.amount) 
FROM kon LEFT JOIN ticket ON kon.id = ticket.kon_id
WHERE ticket.package IS NOT NULL
GROUP BY kon.id

```

At the moment, the output looks like this

```
1   alex    44
2   peter   23

```

but it should look like this

```
1   alex    44
3   john    NULL
2   peter   23

```

I use a MySQL Server.
Is it possible to solve this?