How come "Women + Men" does not add up to "Total"?

Screen Link:

My Code:

SELECT Major_category, Women, Men, Total, Women + Men
  FROM recent_grads
 GROUP BY Major_category

What I expected to happen:
Women + Men = Total

What actually happened:

First 4 rows:
Major_category                  | Women | Men | Total | Women + Men
Agriculture & Natural Resources | 12223 | 4754 | 1488 | 16977
Arts                            | 11931 | 7022 | 43249| 18953
Biology & Life Science          | 5359  | 3050 | 8409 | 8409

Hi @peichek:

Do you mind providing a question link as per these guidelines?

Thanks for letting me know and sorry for the missing info! The link to my question is provided.

1 Like