SQL query for users who have posted on a date (or date range)

[pfaffman (Jay Pfaffman)]

Active users in the last 30 days

Active users in the last 30 days select username from users where last_posted_at > current_timestamp - interval '30' day