turbot/powerpipe-mod-videogames

Query: videogames_average_platform_meta_score_per_genre

Usage

powerpipe query videogames.query.videogames_average_platform_meta_score_per_genre

SQL

select
genres,
avg(cast(substring_index(substring_index(substring_index(`platforms_info`, "'Platform Metascore': '", -1), "'", 1), "'", 1) as unsigned)) as "Average Platform Meta Score"
from
game_data
where
`platforms_info` like "%'Platform Metascore'%"
and genres is not null
group by
genres
order by
"Average Platform Meta Score" desc
limit 10;

Dashboards

The query is used in the dashboards: