Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- SubscriberKey,
- Month,
- COUNT(Score) AS Count_by_Month
- FROM Table1
- GROUP BY Month, Count_by_Month, Score, SubscriberKey
- SubscriberKey Score Month Count_by_Month
- 1234 5 08 2
- 2345 8 08 2
- 3456 10 09 1
- 4567 1 10 1
Add Comment
Please, Sign In to add comment