I have a survey that asks customers about the quality of service they receive from our helpdesk. I need to build a report that averages the response against the following scores -
25 very bad
A typical row in my database will show
Date l response l fix_time l competency l
2012.01 l very good l excellent l very bad l
2012.01 l very good l satisfactory l very bad l
2012.01 l very bad l good l good l
I am struggling to work out how i can build the SQL statement to show this. Can anyone guide me?