Search results

Thanks for the response! The problem I'm having is that I'm getting results like this: projMonth | RiskType | ScoreCount 1 | Low | 2 2 | Low | 5 1 | Medium | 4 2 | Medium | 2 3 | Medium | 5 1 | High | 12 2 | High | 5 3 | High | 1 12 | High | 1 1 | Unknown | 4 2 | Unknown | 1 3 | Unknown |...

Hi everyone! I have a database that tracks the risk scores (NBScore) of projects being introduced into the system. The risk score is on a scale from 1-9. What I need to do is generate a report that shows the number of low risk(1-3), medium risk (4-6), high risk (7-9), and unknown score (NULL)...