data-distribution.md

Data distribution

This script is in:

• Postgres: tables_data_distribution_statistics
• SQL Server: tables_data_distribution_statistics

competitions by country/region

select competition_country, count(distinct season_name) seasons
from matches m
group by competition_country
order by seasons DESC;

competitions count by country/region

select competition_country, count(distinct competition_name) competitions
from matches m
group by competition_country
order by competitions DESC;

seasons by country/region

select distinct competition_country, season_name
from matches m
order by competition_country;

seasons2 by country/region

select distinct competition_country, season_name
from matches m
order by season_name;

recent season by country/region

select competition_country, competition_name, season_name, count(*) matches
group by competition_country, competition_name, season_name
order by season_name DESC;