I am super new to running these queries, and this database in general. I am looking to run a query that shows me the day of last activity for each group. I'd love to be able to pull in the date of creation and who owns the group, but that's another story for another time. I came across the discussion, Day of Latest Activity for Each Group, and that seems to run fine but it includes groups that have already been deleted.
Is there a way to exclude groups that have already been deleted, or at least show that it's already inactive/deleted?