Advertisement
Guest User

Untitled

a guest
Nov 15th, 2019
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. WITH MaxPerDay as (
  2. SELECT
  3. CustomerID,
  4. CONVERT(VARCHAR, STARTDATE, 105) as 'Day',
  5. MAX(SCORE) as 'MaxScore'
  6. FROM
  7. Interactions
  8. GROUP BY CustomerId, CONVERT(VARCHAR, STARTDATE, 105)
  9. )
  10. SELECT
  11. MaxPerDay.CustomerID,
  12. SUM(MaxPerDay.MaxScore)
  13. from MaxPerDay
  14. GROUP BY MaxPerDay.CustomerID
  15. order by SUM(MaxPerDay.MaxScore) desc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement