Back

Answered by wlldodsn

SELECT name, weight, height/100 AS ht_m, ROUND(weight/((height/100)*(height/100)), 2) AS bmi 
FROM heroes_information
WHERE race = 'Human'
ORDER BY bmi DESC
LIMIT 10;

Answered by anonymousUser

select 
	name, 
    weight, 
    height / 100 as ht_m,
    round(weight / pow( height / 100, 2),2) as bmi
from heroes_information
where race = 'Human'
order by bmi desc
limit 10;

Answered by aaaaaaaaaaaaaaaaa

SELECT 
	*,
    ROUND(weight / (ht_m * ht_m), 2) AS bmi
FROM (
  	SELECT name, weight, height / 100 AS ht_m    
	FROM heroes_information
    WHERE race = 'Human'
) h
ORDER BY bmi DESC NULLS LAST
LIMIT 10;