query help

[Richard Reina]

I have a table like this:

|ORDERS|
|ID    | DATE     | QNT | LEAD |
|342  | 8-12-12 | 32   | F        |
|345  | 8-15-12 | 12   | S        |
|349  | 8-16-12 | 9     | R        |

I am looking for a way to query it with counts by the LEAD column in
order to tell what the number of each type lead is, so that I get
something like this:

F_LEADS  S_LEADS  R_LEADS
 44             122         32

Is this possible?  If so can anyone help with syntax?

Thanks,

Richard