Take the 2-minute tour ×  I am using an Oracle DB.  I have ONE
table: Cars.  It has three fields  Race - Car - Finish  The Car
is essentially the ID field. The race is the name of the race.
The Finish is where the car placed: (1st, 2nd, 4th, DNF).  I
want to return how many times a certain car finished at each
position, including the zero instances. So the end result would
be:  Finish         Amount 1st            3 2nd            0 3rd
2 DNF            0  I've tried NVL to return zero when a car
does not have a 2nd place finish: select Finish,
count(nvl(finish)) from cars where Car = 'Toyota'; But this
still only returns the 1st and 3rd place finish counts.  I am
pretty much a beginner at SQL so I have been reading up all the
zero count questions I could find on this site and elsewhere and
cannot generalize the advice to my particular situation.  EDIT
TO INCLUDE TABLE: I am including the table for clarification.
The "Race" field is really not important for this task as I am
only trying to count "f