I want to get a list of all users who haven't posted in a week. But when I use the following function.
select user_id, max(tweet_createdat) from tweets where datediff(now(),max(tweet_createdat)) > 7; Is producing the error: Invalid use of group function