\c hurricane

CREATE OR REPLACE FUNCTION maxx_wind_gt(hhid varchar)
RETURNS integer
LANGUAGE SQL
AS $$
  select max(maxsustained) from observation where hid=hhid;
$$;

--select hid, name, maxx_wind_gt(hid) from hurricane;

CREATE OR REPLACE FUNCTION powerr_gt(speed integer, rotor integer)
RETURNS integer
LANGUAGE SQL
AS $$
  select 0.000133 * 0.4 * rotor * rotor * 3.14 * speed * speed * speed;
$$;