Spotlight archive
Guess the language.
Three lines, three guesses.
MODESpotlight0/3
Spotlight · ?.??
1WITH active_users AS (SELECT id, email FROM users WHERE is_active = TRUE)
2SELECT au.email, COUNT(*) FROM active_users au JOIN orders o ON o.user_id = au.id
3GROUP BY au.email;
$ identify language
scripting
compiled
query
Keep going