An interviewer asked me this scenario in a job interview.
We have an
GENDER NAME ------ ----- M A F B F C M D
How can we write a query to output this:
MALES FEMALES ----- ----- A B D C
So we need all the Males in the first column, and all the Females in the second name column. The names can be in any order.