SQL did you know that you can change is not null to not is null.
Great
This looks like homework (can't imagine any business purpose). Please have a go and post your query, working or not.
BTW I assume you mean two-letter combos?
Yes two letter combos, I will attempt and post later.