Bemmu

SELECT
  b.country,
  SUM(score) as total_score,
  SUM(a.c) as mention_count,
  ROUND(SUM(score) / SUM(a.c), 2) as avg_score
FROM
(
  SELECT
    a.word,
    SUM(a.score) AS score,

rvanbruggen

Respondent;Age;Gender;OrgType;OrgSize;Position;Role-Marketing;Role-Sales;Role-Finance;Role-Production;RoleRD;RoleIT;Support;Industry;DegreeLevel;DegreeField-ScienceMathematics;DegreeField-Engineering;DegreeField-ICT;DegreeField-Commerce;DegreeField-Social;DegreeField-Law;DegreeField-Other;DataScienceExperience;Techniques-Algo;Techniques-Backend;Techniques-Bayes;Techniques-BigData;Techniques-Business;Techniques-Stats;Techniques-DataMan;Techniques-FrontEnd;Techniques-Graph;Techniques-ML;Techniques-Math;Techniques-Optimization;Techniques-ProdDev;Techniques-Science;Techniques-Simul;Techniques-Spatial;Techniques-StructData;Techniques-SurvMark;Techniques-SysAdmin;Techniques-Temp;Techniques-UnstructData;Techniques-Viz;DataScientistType-Developer;DataScientistType-Engineer;DataScientistType-Researcher;DataScientistType-Scientist;DataScientistType-Statistician;DataScientistType-JackOfAllTrades;DataScientistType-Artist;DataScientistType-Hacker;DataScientistType-Leader;DataScientistType-BizPerson;DataScientistType-Entre