Spotlight archive
Guess the language.
Three lines, three guesses.
MODESpotlight0/3
Spotlight · ?.??
1UPDATE users u SET status = 'churned'
2FROM (SELECT user_id FROM orders GROUP BY user_id HAVING MAX(created_at) < NOW() - INTERVAL '90 days') s
3WHERE u.id = s.user_id;
$ identify language
scripting
compiled
query
Keep going