Comments

Community Chosen Answer

Answers

1

I have were it will list all satisfaction numbers for a particular year:

SELECT HD_TICKET.SATISFACTION_RATING AS HD_TICKET_SATISFACTION_RATING, HD_TICKET.TIME_CLOSED AS HD_TICKET_TIME_CLOSED FROM HD_TICKET WHERE (HD_TICKET.HD_QUEUE_ID = 1) AND ( HD_TICKET.SATISFACTION_RATING NOT LIKE '%0%' AND DATE(HD_TICKET.TIME_CLOSED) LIKE '%2009%') ORDER BY HD_TICKET.TIME_CLOSED asc,HD_TICKET.SATISFACTION_RATING asc