data sample:
red Fri Apr 08 07:00:00 EDT 2022 Fri Apr 08 15:00:00 EDT 2022 0 0
blue Fri Apr 08 07:00:00 EDT 2022 Fri Apr 08 15:00:00 EDT 2022 65 7
blue Fri Apr 08 07:00:00 EDT 2022 Fri Apr 08 15:00:00 EDT 2022 65 8
green Fri Apr 08 07:00:00 EDT 2022 Fri Apr 08 15:00:00 EDT 2022 11 1
purple Fri Apr 08 07:00:00 EDT 2022 Fri Apr 08 15:00:00 EDT 2022 11 3
pruple Fri Apr 08 07:00:00 EDT 2022 Fri Apr 08 15:00:00 EDT 2022 11 5
orange Fri Apr 08 07:00:00 EDT 2022 Fri Apr 08 15:00:00 EDT 2022 12 8
orange Fri Apr 08 07:00:00 EDT 2022 Fri Apr 08 15:00:00 EDT 2022 12 8
teal Fri Apr 08 07:00:00 EDT 2022 Fri Apr 08 15:00:00 EDT 2022 14 9
teal Fri Apr 08 07:00:00 EDT 2022 Fri Apr 08 15:00:00 EDT 2022 14 5
black Fri Apr 08 07:00:00 EDT 2022 Fri Apr 08 15:00:00 EDT 2022 15 9
black Fri Apr 08 07:00:00 EDT 2022 Fri Apr 08 15:00:00 EDT 2022 15 1
magenta Fri Apr 08 07:00:00 EDT 2022 Fri Apr 08 15:00:00 EDT 2022 18 7
brown Fri Apr 08 07:00:00 EDT 2022 Fri Apr 08 15:00:00 EDT 2022 19 9
gray Fri Apr 08 07:00:00 EDT 2022 Fri Apr 08 15:00:00 EDT 2022 19 1
gray Fri Apr 08 07:00:00 EDT 2022 Fri Apr 08 15:00:00 EDT 2022 19 1
I need only one row for each color in my query summed
Ideal output:
Fri Apr 08 07:00:00 EDT 2022 Fri Apr 08 15:00:00 EDT 2022 sumOfColumn, sumOfNextColumn
My query is complex
Has join, filtering of words, and lots of summing with math
I think if I could see how to sort specific colors to sum correctly, I can solve my query.
I think I need to use rank.
updated 2022 04 11 1650