Extracting Course IDS for specific faculty members

We are using ASR DB. I am looking for a query to extract list of course ID's to which faculty members A,B,C are connected/enrolled to. If this query can also show me the courses that has content and courses that do not have content.

Example: Faculty A.B,C are enrolled in 100 courses. I need to know all these 100 course ID's along with an excel column next to the course ids that says this course has content and this course has no content (null). The only information available with me in order to run this query would be users.pk1 or users.user_id