I have a table with accounts and payment type. Every account MUST have 1 payment type of 'GOGW', 1 account may have multiple payment types.

I need to find a way to identify which accounts don't have a 'GOGW' please

table1

| Account | Type |
| --- | --- |
| 123456 | Cheque |
| 123456 | GOGW |
| 654321 | Direct Debit |
| 654321 | GOGW |
| 987654 | Direct Debit |
| 456789 | BACS |

should return

| Account | Type |
| --- | --- |
| 987654 | Direct Debit |
| 456789 | BACS |