Identifiers need to be quoted with double quotes ("). Single quotes (') denote a character value (not a “name”).
Therefor you need to use:
SUM(part_gold) as "Number of Gold Medals"
More details in the manual:
- Database Object Names and Qualifiers
- Text literals