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):
| programname | class | numObjs |
| apbias | GALAXY | 1168 |
| apbias | QSO | 355 |
| apbias | STAR | 397 |
| boss | GALAXY | 1549183 |
| boss | QSO | 518867 |
| boss | STAR | 314950 |
| boss_lofar | GALAXY | 2405 |
| boss_lofar | QSO | 1263 |
| boss_lofar | STAR | 332 |
| commissioning | GALAXY | 69643 |
| commissioning | QSO | 28509 |
| commissioning | STAR | 22048 |
| DEEP_QSO | GALAXY | 2608 |
| DEEP_QSO | QSO | 2747 |
| DEEP_QSO | STAR | 645 |
| disk | GALAXY | 194 |
| disk | QSO | 192 |
| disk | STAR | 11134 |
| eboss | GALAXY | 155801 |
| eboss | QSO | 206575 |
| eboss | STAR | 62624 |
| fstars | GALAXY | 175 |
| fstars | QSO | 541 |
| fstars | STAR | 5684 |
| hyades | GALAXY | 166 |
| hyades | QSO | 200 |
| hyades | STAR | 274 |
| legacy | GALAXY | 1051085 |
| legacy | QSO | 167277 |
| legacy | STAR | 217798 |
| lowz | GALAXY | 10201 |
| lowz | QSO | 638 |
| lowz | STAR | 1321 |
| lowz_loveday | GALAXY | 568 |
| lowz_loveday | QSO | 20 |
| lowz_loveday | STAR | 52 |
| lowz_lrg | GALAXY | 29545 |
| lowz_lrg | QSO | 1203 |
| lowz_lrg | STAR | 3812 |
| m31_fstars | GALAXY | 58 |
| m31_fstars | QSO | 113 |
| m31_fstars | STAR | 1749 |
| msturnoff | GALAXY | 186 |
| msturnoff | QSO | 149 |
| msturnoff | STAR | 6065 |
| orion | GALAXY | 561 |
| orion | QSO | 370 |
| orion | STAR | 6749 |
| Orion_Taurus | GALAXY | 2127 |
| Orion_Taurus | QSO | 3587 |
| Orion_Taurus | STAR | 2286 |
| perseus | GALAXY | 471 |
| perseus | QSO | 66 |
| perseus | STAR | 743 |
| photoz | GALAXY | 14049 |
| photoz | QSO | 859 |
| photoz | STAR | 1092 |
| preboss | GALAXY | 6052 |
| preboss | QSO | 2103 |
| preboss | STAR | 2085 |
| premarvels_preselection | GALAXY | 4110 |
| premarvels_preselection | QSO | 5058 |
| premarvels_preselection | STAR | 6192 |
| reddening | GALAXY | 938 |
| reddening | QSO | 560 |
| reddening | STAR | 4262 |
| RM | GALAXY | 48593 |
| RM | QSO | 954988 |
| RM | STAR | 81419 |
| segcluster | GALAXY | 643 |
| segcluster | QSO | 791 |
| segcluster | STAR | 12646 |
| segclusterf | GALAXY | 275 |
| segclusterf | QSO | 320 |
| segclusterf | STAR | 4525 |
| seglowlat | GALAXY | 917 |
| seglowlat | QSO | 574 |
| seglowlat | STAR | 11309 |
| seglowlatf | GALAXY | 502 |
| seglowlatf | QSO | 353 |
| seglowlatf | STAR | 6185 |
| segpointed | GALAXY | 368 |
| segpointed | QSO | 326 |
| segpointed | STAR | 9546 |
| segpointedf | GALAXY | 483 |
| segpointedf | QSO | 711 |
| segpointedf | STAR | 9046 |
| segtest | GALAXY | 445 |
| segtest | QSO | 561 |
| segtest | STAR | 7314 |
| segtestf | GALAXY | 150 |
| segtestf | QSO | 171 |
| segtestf | STAR | 2239 |
| segue | GALAXY | 4062 |
| segue | QSO | 3583 |
| segue | STAR | 124835 |
| SEGUE_GES | GALAXY | 590 |
| SEGUE_GES | QSO | 2896 |
| SEGUE_GES | STAR | 13514 |
| segue2 | GALAXY | 3750 |
| segue2 | QSO | 5351 |
| segue2 | STAR | 134899 |
| seguefaint | GALAXY | 7142 |
| seguefaint | QSO | 8435 |
| seguefaint | STAR | 104103 |
| sequels | GALAXY | 47078 |
| sequels | QSO | 46988 |
| sequels | STAR | 22934 |
| SEQUELS_ELG | GALAXY | 6483 |
| SEQUELS_ELG | QSO | 1936 |
| SEQUELS_ELG | STAR | 581 |
| southern | GALAXY | 36451 |
| southern | QSO | 12010 |
| southern | STAR | 41139 |
| special_elg | GALAXY | 1438 |
| special_elg | QSO | 435 |
| special_elg | STAR | 127 |
| special_plates_NGC | GALAXY | 22889 |
| special_plates_NGC | QSO | 3267 |
| special_plates_NGC | STAR | 2844 |
| special_plates_S82 | GALAXY | 167 |
| special_plates_S82 | QSO | 699 |
| special_plates_S82 | STAR | 134 |
| special_plates_TDSS_SPIDERS | GALAXY | 45 |
| special_plates_TDSS_SPIDERS | QSO | 415 |
| special_plates_TDSS_SPIDERS | STAR | 540 |
| special_plates_W1 | GALAXY | 199 |
| special_plates_W1 | QSO | 553 |
| special_plates_W1 | STAR | 248 |
| special_plates_W3 | GALAXY | 2473 |
| special_plates_W3 | QSO | 433 |
| special_plates_W3 | STAR | 94 |
| special_sky | GALAXY | 1262 |
| special_sky | QSO | 2140 |
| special_sky | STAR | 598 |
| taurus | GALAXY | 58 |
| taurus | QSO | 99 |
| taurus | STAR | 1763 |
| XMMXLL | GALAXY | 1130 |
| XMMXLL | QSO | 2604 |
| XMMXLL | STAR | 266 |