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

Your query output (max 500,000 rows):

programnameclassnumObjs
apbiasGALAXY1168
apbiasQSO355
apbiasSTAR397
bossGALAXY1545295
bossQSO516595
bossSTAR321110
boss_lofarGALAXY2385
boss_lofarQSO1257
boss_lofarSTAR358
commissioningGALAXY69949
commissioningQSO27311
commissioningSTAR22940
DEEP_QSOGALAXY2576
DEEP_QSOQSO2726
DEEP_QSOSTAR698
diskGALAXY194
diskQSO192
diskSTAR11134
ebossGALAXY378209
ebossQSO522654
ebossSTAR165137
ELG_NGCGALAXY117235
ELG_NGCQSO27807
ELG_NGCSTAR5958
ELG_SGCGALAXY161332
ELG_SGCQSO33882
ELG_SGCSTAR7786
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
Orion_TaurusGALAXY2288
Orion_TaurusQSO3309
Orion_TaurusSTAR2403
perseusGALAXY471
perseusQSO66
perseusSTAR743
photozGALAXY14049
photozQSO859
photozSTAR1092
prebossGALAXY6052
prebossQSO2103
prebossSTAR2085
premarvels_preselectionGALAXY4110
premarvels_preselectionQSO5058
premarvels_preselectionSTAR6192
reddeningGALAXY938
reddeningQSO560
reddeningSTAR4262
RMGALAXY56189
RMQSO1660505
RMSTAR145306
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
SEGUE_GESGALAXY822
SEGUE_GESQSO2493
SEGUE_GESSTAR13685
segue2GALAXY3750
segue2QSO5351
segue2STAR134899
seguefaintGALAXY7142
seguefaintQSO8435
seguefaintSTAR104103
sequelsGALAXY47977
sequelsQSO45818
sequelsSTAR23205
SEQUELS_ELGGALAXY6576
SEQUELS_ELGQSO1847
SEQUELS_ELGSTAR577
southernGALAXY36451
southernQSO12010
southernSTAR41139
special_elgGALAXY1465
special_elgQSO405
special_elgSTAR130
special_plates_NGCGALAXY23024
special_plates_NGCQSO3134
special_plates_NGCSTAR2842
special_plates_S82GALAXY162
special_plates_S82QSO711
special_plates_S82STAR127
special_plates_TDSS_SPIDERSGALAXY43
special_plates_TDSS_SPIDERSQSO416
special_plates_TDSS_SPIDERSSTAR541
special_plates_W1GALAXY203
special_plates_W1QSO544
special_plates_W1STAR253
special_plates_W3GALAXY2484
special_plates_W3QSO425
special_plates_W3STAR91
special_skyGALAXY1092
special_skyQSO2260
special_skySTAR648
taurusGALAXY58
taurusQSO99
taurusSTAR1763
XMMXLLGALAXY1111
XMMXLLQSO2615
XMMXLLSTAR274