select count(*), risk_level from geohazard_all_english group by risk_level
运行结果:
select count(*), risk_level from geohazard_all_english where risk_level in('较低','低','中','中等','较高','高') group by risk_level
运行结果:
select count(*), risk_level from geohazard_all_english group by risk_level
运行结果:
select count(*), risk_level from geohazard_all_english where risk_level in('较低','低','中','中等','较高','高') group by risk_level
运行结果: