can any one help i need to do a query for our user database

I have two colums.

One is Department
One is Realname

What i would like to do is to list all users apart from those who's department = no longer employed