I need to write a query that will calculate three diff perecentages and I am unsure how to do so.
I have a table that with a column called "COMPLETED". I need to write a query that will pull all records from this table and tell me what percent have a value of "Y" in this column or a value of "N" or if its null or empty, then that means it has not been started.
So I have 10 records in this table, each has a value of Y, N, or NULL or empty for this column. Out of the total records returned, I need to know what percent have a value of "Y", and what percent have a valuer of "N", and what percent have a value of NULL or empty string. I guess they columns can be aliased as percentComplete, percentIncomplete, percentNotStarted or something.
Any help appreciated........