# select count(*), phenomena, avg( area(transform(geom, 2163)) ) from warnings_2006 WHERE gtype = 'P' GROUP by phenomena;
 count | phenomena |       avg
-------+-----------+------------------
  3385 | MA        | 3463492186.44138
  3406 | FF        | 1932808511.52821
  2758 | TO        |  897018583.41466
 24024 | SV        | 1175341135.44903

# select phenomena, avg(s) from (select phenomena, eventid, wfo, sum( area(transform(geom, 2163)) ) as s from warnings_2006 WHERE significance = 'W' and gtype = 'C' GROUP by phenomena, eventid, wfo) as foo GROUP by phenomena;
 phenomena |       avg
-----------+------------------
 BZ        | 32438298270.1351
 CF        | 5714500986.21949
 DS        | 18905782739.8863
 EH        | 41642575346.7558
 FW        | 41138699355.3943
 FZ        |  27587205711.483
 GL        | 7000769722.71335
 HI        | 5809987056.53516
 HS        | 26687557244.4859
 HW        | 21034016055.8155
 IS        | 14202335479.6079
 LE        | 6883801143.34386
 MA        | 8311466113.62591
 SV        | 3935151633.22503
 TI        | 14134923127.3096
 TO        | 3077641818.80033
 WC        | 46426242233.0177
 WS        | 28816146806.9404

# select count(*), phenomena, avg( area(transform(geom, 2163)) ) from
# warnings_2005 WHERE gtype = 'P' GROUP by phenomena;
 count | phenomena |       avg
-------+-----------+------------------
  3497 | FF        |  2716785587.1166
  1016 | MA        | 4496697140.83785
     2 |           | 1602719616.68085
  2979 | TO        | 1037065564.27891
 21218 | SV        | 1293230234.18805


# select phenomena, avg(s) from (select phenomena, eventid, wfo, sum(
# area(transform(geom, 2163)) ) as s from warnings_2005 WHERE significance =
# 'W' and gtype = 'C' GROUP by phenomena, eventid, wfo) as foo GROUP by
# phenomena;
 phenomena |       avg
-----------+------------------
 BZ        | 26896830481.7676
 FZ        | 33547191275.5579
 HS        | 27616428820.9468
 HW        | 23607062666.9915
 IS        |   24221201401.52
 LE        | 8894566638.02024
 MA        | 12593040497.6261
 SV        | 4314200623.95968
 TO        | 3563704013.76516
 WC        | 25459850469.3808
 WS        | 23895148492.4808