SELECT Major_category, CAST(SUM(Women) AS Float )/CAST( SUM(Total) AS Float) as SW from recent_grads group by Major_category order by SW
What I expected to happen:
I expected to find a table of Major_category and SW which is indeed what I got. Dataquest platform approved my answer as correct.
But I see that the share of women (SW) column has values that are above 1 indicating for example that the average Major in Agriculture & Natural Resources consists of 300%.