Channels a member is a part of

```sql
SELECT 
    c.displayName, 
    c.name
FROM 
    channels c
JOIN 
    channelmembers cm ON c.id = cm.channelid
JOIN 
    users u ON cm.userid = u.id
WHERE 
    u.username = 'professor';
```