What are the top databases per country?

To find the top databases per country that people want to work on:

SELECT Country, c
  , ARRAY(
    SELECT AS STRUCT value, count, ROUND(100*count/SUM(count) OVER(PARTITION BY Country), 2) percent FROM UNNEST(v)
  ) v
FROM (
  SELECT Country, APPROX_TOP_COUNT(v, 10) v, COUNT(*) c
  FROM (
    SELECT Country, SPLIT(WantWorkDatabase, '; ') v
    FROM `fh-bigquery.stackoverflow.survey_results_public_2017`
  ), UNNEST(v) v
  WHERE v!='NA'
  GROUP BY 1
  HAVING c>10
  ORDER BY c DESC
)
ORDER BY c DESC

It's interesting to observe the variations between different countries.

The US top interests are PostgreSQL, SQL Server, and MongoDB:

While India is not very interested in PostgreSQL:

And the UK is very interested in SQL Server:

And Germany has both MySQL and PostgreSQL on top:

Most countries are not very interested in Cassandra or Oracle, but Israel shows a surprising interest for Cassandra:

While Pakistan shows above average interest for Oracle:

Charting the interest for MySQL, MongoDB and PostgreSQL:

And the rest, on an interactive Data Studio dashboard.

(feel free to tag me on https://twitter.com/felipehoffa)