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