Sql is not null

SQL did you know that you can change is not null to not is null.

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.