Subquery in arithmetic expression in select statement

Why does the final column return 0? Also is there a simpler way to accomplish my goal here (the activity wants me to hardcode the numbers which is dumb).

Hardcoding numbers leads to a result the automatic checking routine can verify.

If you examine the data, you might be able to determine why the proportion returns 0.0.
Can you provide a link to the exercise to add context?