TicketSQL to search for groups in Cc

We’ve got (named) groups in the ticket’s Cc: field.

Is there an easy way to create a TicketSQL query from the query builder
that does “Cc” is “group’s name” ?

One of the dropdowns starts “RequestorEmailAddress” and lists things for
that, then Cc, Admin Cc, Watcher and Owner. However, all the things checked
for are for Users, not Groups.

So I can’t see an obvious way to craft a query to look for a particular
group in the Cc list. Is there a way to do this from the frontend?

Nicholas Clark