Sorry if this has already been asked before; I wasn't sure how to
formulate a search for what I'm trying to do.
I would like to do something similar to the following:
Lets say that I have a column that can contain four distinct values:
For example; What is your class level? (Freshman, Sophomore, Junior,
All of the responses would be stored in the column CLASS_LEVEL in the
How could I produce the counts of each in one request?
I am trying to do something like this.
count(CLASS_LEVEL) where CLASS_LEVEL = "Freshman" as FRCOUNT,
count(CLASS_LEVEL) where ...