Yes that is what I want. In my world:

A list of all active courses in department 10 only.

There are 10 departments which have courses listed in the database. Each department has a unique identifer for their courses. Each department have active and inactive courses listed.

Thanks for your words of kindness...