Hi. I have a table that is structured as the following:
TestRecord
User1
User2
User 3
so the data looks like this
Pass UserA UserB UserC
Pass UserB UserC Null
Fail UserA UserB Null
Pass UserA UserB Null
Pass UserC UserA Null
Pass UserB UserA UserC
Any ideas on how to write a sql statement that will count the number of occurences a specific user shows up in a record.
So....
UserA 5
User B 5
USer C 4
I am not even sure where to start or of this is possible.
Our community of experts have been thoroughly vetted for their expertise and industry experience.