Delete avatars by usergroup

[Night Owl]

I need to delete all avatars belonging to users in a specific usergroup. What query can I use to do this?

[filburt1]

I think:

DELETE FROM customavatar WHERE user.userid = customavatar.userid AND user.usergroupid = usergroupid;