Subject This SQL conundrum is breaking my head
Author Clay Shannon
From a table that stores such things about a job applicant as gender, race,
disability, veteran status, etc. and which table also holds an "Action
taken" column (which can be:


Not Interviewed

Interviewed-job declined

Did not meet qualifications


I need to be able to see which actions were taken by gender, by race, etc.

The only "start" that I can come up with is something like:

Select gender, Count(ActionTaken)

From Applicants

Where Action = Hired

Group by Gender

But I need the results for every action taken, not just "Hired" - I need
results like:

Gender Hired Not Interviewed Did Not
Meet Quals

Male 2 3

Female 3 2

Clay Shannon,

Dimension 4 Software

[Non-text portions of this message have been removed]