统计SDSS DR16数据库中‘Galaxy’类的子分类和各自的个数
select subclass,count(*) from SpecObj
where zwarning = 0
and class = 'GALAXY'
group by subclass
结果
统计SDSS DR16数据库中‘Galaxy’类的子分类和各自的个数
select subclass,count(*) from SpecObj
where zwarning = 0
and class = 'GALAXY'
group by subclass
结果