Your SQL command was:
SELECT plate.programname, class, 
COUNT(specObjId) AS numObjs 
FROM SpecObjAll
JOIN PlateX AS plate ON plate.plate = specObjAll.plate
GROUP BY plate.programname, class
ORDER BY plate.programname, class

programnameclassnumObjs
apbiasGALAXY1168
apbiasQSO355
apbiasSTAR397
bossGALAXY999550
bossQSO317432
bossSTAR206018
commissioningGALAXY35005
commissioningQSO14156
commissioningSTAR12039
diskGALAXY194
diskQSO192
diskSTAR11134
fstarsGALAXY175
fstarsQSO541
fstarsSTAR5684
hyadesGALAXY166
hyadesQSO200
hyadesSTAR274
legacyGALAXY1051085
legacyQSO167277
legacySTAR217798
lowzGALAXY10201
lowzQSO638
lowzSTAR1321
lowz_lovedayGALAXY568
lowz_lovedayQSO20
lowz_lovedaySTAR52
lowz_lrgGALAXY29545
lowz_lrgQSO1203
lowz_lrgSTAR3812
m31_fstarsGALAXY58
m31_fstarsQSO113
m31_fstarsSTAR1749
msturnoffGALAXY186
msturnoffQSO149
msturnoffSTAR6065
orionGALAXY561
orionQSO370
orionSTAR6749
perseusGALAXY471
perseusQSO66
perseusSTAR743
photozGALAXY14049
photozQSO859
photozSTAR1092
prebossGALAXY6052
prebossQSO2103
prebossSTAR2085
premarvels_preselectionGALAXY4110
premarvels_preselectionQSO5058
premarvels_preselectionSTAR6192
reddeningGALAXY938
reddeningQSO560
reddeningSTAR4262
segclusterGALAXY643
segclusterQSO791
segclusterSTAR12646
segclusterfGALAXY275
segclusterfQSO320
segclusterfSTAR4525
seglowlatGALAXY917
seglowlatQSO574
seglowlatSTAR11309
seglowlatfGALAXY502
seglowlatfQSO353
seglowlatfSTAR6185
segpointedGALAXY368
segpointedQSO326
segpointedSTAR9546
segpointedfGALAXY483
segpointedfQSO711
segpointedfSTAR9046
segtestGALAXY445
segtestQSO561
segtestSTAR7314
segtestfGALAXY150
segtestfQSO171
segtestfSTAR2239
segueGALAXY4062
segueQSO3583
segueSTAR124835
segue2GALAXY3750
segue2QSO5351
segue2STAR134899
seguefaintGALAXY7142
seguefaintQSO8435
seguefaintSTAR104103
southernGALAXY36451
southernQSO12010
southernSTAR41139
special_elgGALAXY1174
special_elgQSO663
special_elgSTAR163
special_skyGALAXY1152
special_skyQSO2286
special_skySTAR562
taurusGALAXY58
taurusQSO99
taurusSTAR1763