Finding users who haven't posted in a week

[John Meyer]

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