I've wrote a query which shows the reasons and the amount of the selected reasons people cancel their orders per state per year:

```
SELECT   DISTINCT LEFT(k.wijk,2) AS state,
         YEAR(a.eind_dt) AS year, 
         opzegreden AS reason, 
         count(*) AS amount
FROM     klant AS k 
JOIN     abon AS a 
ON       k.klant_id = a.lezer
WHERE    opzegreden IS NOT NULL
GROUP BY LEFT(k.wijk,2), year(a.eind_dt), opzegreden
ORDER BY state, year, reason;

```

Which gives this result atm:
[Current result](https://i.stack.imgur.com/MfRbD.png)

Now the only thing I can't seem to make happen is to show the reason which is picked the most per state per year. Which would be reason nr 14 with my current result.

Can someone please help me?