videogames_average_platform_meta_score_per_genrevideogames_top_10_by_user_ratings_countvideogames_top_10_by_user_scorevideogames_top_10_developers_by_game_countvideogames_top_10_genre_distributionvideogames_top_10_publishers_by_game_countvideogames_totalvideogames_total_developersvideogames_total_platformsvideogames_total_publishers
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_datawhere `platforms_info` like "%'Platform Metascore'%" and genres is not nullgroup by genresorder by "Average Platform Meta Score" desclimit 10;
Dashboards
The query is used in the dashboards: