I'll do my best to explain what I'm trying to accomplish.
I have a table called "Actions" and in Actions I have a column called "Resolution". In resolution some the entries, as an example, are "Fail", "Pending", "Completed" and "Cancelled".
I am trying to write a query that will tell me what percentage of the entries are "Cancelled". I hope I've explained myself. I am fairly new to SQL so please bear with me.