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_total_platforms
Usage
powerpipe query videogames.query.videogames_total_platforms
SQL
select count(distinct substring_index( substring_index( substring_index(`platforms_info`, "'Platform': '", -1), "'", 1 ), "'", 1 )) as "Total Platforms"from game_datawhere `platforms_info` like "%'Platform'%";
Dashboards
The query is used in the dashboards: