Let’s say we define
status for every student who gets marks over 33 as
Passed and others as
Write a query to show count of students for all unique combinations of
grade is present
The headers for
count of students should be
The result should look something like this.
You can use
CASE..WHEN..THEN..ELSE..ENDsyntax to get conditional data from a row and wrap its result with an alias.
An alias can also be used in a