如何使用GROUP BY子句过滤SQL查询

I'm trying to formulate an SQL query for a messaging system that will return a list of all threads which have a status of 'OPEN' and whose last message was not posted by a user in a certain group.I'm trying to formulate an SQL query for a mess