turbot/videogames

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_data
where `platforms_info` like "%'Platform'%";

Dashboards

The query is used in the dashboards: