/*
Get name of parts that have the <B>second</B> highest weight.

select pname
from   part P
where
       weight >= ALL (weight of parts that are not the heaviest)
  and  weight != max(weight of parts)
*/

select pnum
from   part P
where  weight >= ALL (select weight
                      from   part
                      where  weight < (select max(weight) from part)
                     )
  and weight != (select max(weight) from part)
