I have this table:
I need to count every row where tblEventID is 32. So the result will be 3. (easy aggregate function):
SELECT COUNT(status) FROM ...
I need to also add the value in column
plusOnes to the overall.
So the result must be 3 (count) + 2 + 2 + 0 = 7.
Meaning I have to look at each row individually, add the value from plus one and in the end add the total count.
How is this achieved?
Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.
You can achieve this by adding the count of rows, and the sum of plusOnes together
SELECT COUNT(status) + SUM(plusOnes) FROM ...