I have the following table structure:

PCID                     QTY         BARCODE           AVAILABLE

3U60LB987              4           cIV3V00TCJ42         .T.
3U60LB987              4           cIV3V00TCJ43         .T.
3U60LB987              4           cIV3V00TCJ44         .T.
3U60LB987              4           cIV3V00TCJ45         .T.
3U60LB987              4           cIV3V00TCJ46         .F.
3V60K0MGW           1           cIV3V60K1GA0       .T.

I would like the output to look like:

PCID                     QTY          NO_AVAIL        NO_NOTAVAIL
3U60LB987              4                   4                        1
3V60K0MGW           1                   1                        0

Can this be done with an sql statement?

Thanks in advance,