Games Seen In Person

Bar Chart showing the number of games seen in Person.

Owned by ryan, visibility: Public

SQL query
select extract(year from b.game_date) as bar_label
, count(*) bar_quantity
from public.game_usergame a
inner join public.game_game b on a.game_id = b.game
inner join public.users c on a.user_id = c.id
inner join public.venue_venue d on b.venue_id = mlb_api_venue
where a.view_type = 'P'
group by extract(year from b.game_date)
order by 1, 2