SELECT country, CAST(avg(bore*bore*bore/2) AS NUMERIC(30, 2)) AS weight
FROM (
   SELECT country, bore
   FROM Classes cl, Ships ship
   WHERE cl.class = ship.class


   UNION

   SELECT country, bore
   FROM Classes, Outcomes
   WHERE ship = class AND ship NOT IN (SELECT name FROM Ships)
) Lol
GROUP BY country