Get two percentages in a single query
Posted: Mon Jan 27, 2014 2:41 pm
Ok I have a single table called opportunities, within that table I have field called sales_stage. I need to get the percentage of rows where sales_stage is "Closed Won" and also get percentage of rows where sales_stage is "Closed Lost" And basically just display the two headings Closed won and Closed Lost.
I'm a little bit lost with how to do this one, here is an sql fiddle
http://sqlfiddle.com/#!2/ac28d/13
I'm a little bit lost with how to do this one, here is an sql fiddle
http://sqlfiddle.com/#!2/ac28d/13