select Major_category, sum(Women) as Total_women, avg(ShareWomen) as Mean_women, sum(Total) * avg(ShareWomen) as Estimate_women from recent_grads group by Major_category
What I expected to happen:
I expected this to be the wrong answer. This is what passed the problem. The rubric clearly states that it needs a percentage not a fraction. I expected that multiplying the fraction by 100 to express it as a percentage to be the correct answer. It took quite some time to track this down and it was just frustrating when I started playing with the answer and it worked.
What actually happened:
Replace this line with the output/error