Testing indented codeblock

General
1 
-- [params] 
-- string :interval = 1 month 
-- string :trunc = month 

SELECT user_id, count(id) 
FROM user_badges 
WHERE granted_at > date_trunc(:trunc, CURRENT_TIMESTAMP - INTERVAL :interval) 
     AND granted_at < date_trunc(:trunc, CURRENT_TIMESTAMP) 
GROUP BY user_id 
    SELECT user_id, count(id) 
FROM user_badges 
WHERE granted_at > date_trunc(:trunc, CURRENT_TIMESTAMP - INTERVAL :interval) 
     AND granted_at < date_trunc(:trunc, CURRENT_TIMESTAMP) 
GROUP BY user_id 
ORDER BY count DESC

This is an edit

Last checked by

2

This is a very SQL reply