变量观察值之和做除法

select class, id, sum(height)/sum(weight) as rate from want group by class, id;