Any thoughts on why?
Row WantWorkLanguage responses perc_female
1 R 2477 11.87%
2 Ruby 3743 11.03%
3 Java 9409 8.42%
4 Python 11878 8.22%
5 SQL 10646 7.81%
6 Scala 2972 7.64%
7 JS 15451 7.37%
8 Swift 4282 7.36%
9 PHP 5039 7.22%
10 C# 9640 6.21%
11 C++ 7178 5.20%
12 Go 5500 4.87%
13 C 4536 4.83%
14 TypeScr 5435 4.51%
15 Haskell 2208 4.35%
16 Rust 2604 3.38%
(related thread: https://twitter.com/felipehoffa/status/879806078866776064) SELECT WantWorkLanguage, COUNT(*) responses, FORMAT('%.2f%%', 100*COUNTIF(v='Female')/COUNT(*)) perc_female
FROM (
SELECT SPLIT(WantWorkLanguage , '; ') WantWorkLanguage, Gender v
FROM `fh-bigquery.stackoverflow.survey_results_public_2017`
WHERE WantWorkLanguage!='NA' AND Gender!='NA'
), UNNEST(WantWorkLanguage) WantWorkLanguage
GROUP BY 1
HAVING responses>2000
ORDER BY COUNTIF(v='Female')/COUNT(*) DESC