Guest User

Untitled

a guest
Dec 14th, 2018
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.31 KB | None | 0 0
  1. SELECT
  2. SubscriberKey,
  3. Month,
  4. COUNT(Score) AS Count_by_Month
  5. FROM Table1
  6. GROUP BY Month, Count_by_Month, Score, SubscriberKey
  7.  
  8. SubscriberKey Score Month Count_by_Month
  9. 1234 5 08 2
  10. 2345 8 08 2
  11. 3456 10 09 1
  12. 4567 1 10 1
Add Comment
Please, Sign In to add comment