Big5Leagues-Teams Goalkeeping Metrics 22/23
(Team vs. Opponent) and (Opponent vs. Team) Goalkeeping Statistics 2022/2023
@kaggle.hamdallak_big5leagues_teams_goalkeeping_metrics_2223
(Team vs. Opponent) and (Opponent vs. Team) Goalkeeping Statistics 2022/2023
@kaggle.hamdallak_big5leagues_teams_goalkeeping_metrics_2223
CREATE TABLE big5_teams_keeper_statistics (
"team" VARCHAR,
"competition" VARCHAR,
"keepers_played" BIGINT,
"matches_played" BIGINT,
"matches_started" BIGINT,
"minutes_played" BIGINT,
"matches_played_in_90_minutes" BIGINT,
"goals_against" BIGINT,
"goals_against_per_90_minutes" DOUBLE,
"shots_on_target_against" BIGINT,
"saves_made" BIGINT,
"save_percentage" DOUBLE,
"matches_won" BIGINT,
"matches_drawn" BIGINT,
"matches_lost" BIGINT,
"clean_sheets" BIGINT,
"clean_sheet_percentage" DOUBLE,
"penalty_kick_attempts" BIGINT,
"penalty_kicks_awarded" BIGINT,
"penalty_kicks_saved" BIGINT,
"penalty_kicks_missed" BIGINT,
"penalty_kick_save_percentage" DOUBLE
);
CREATE TABLE big5_teams_keeper_statistics_opponent (
"team" VARCHAR,
"competition" VARCHAR,
"keepers_played" BIGINT,
"matches_played" BIGINT,
"matches_started" BIGINT,
"minutes_played" BIGINT,
"matches_played_in_90_minutes" BIGINT,
"goals_against" BIGINT,
"goals_against_per_90_minutes" DOUBLE,
"shots_on_target_against" BIGINT,
"saves_made" BIGINT,
"save_percentage" DOUBLE,
"matches_won" BIGINT,
"matches_drawn" BIGINT,
"matches_lost" BIGINT,
"clean_sheets" BIGINT,
"clean_sheet_percentage" DOUBLE,
"penalty_kick_attempts" BIGINT,
"penalty_kicks_awarded" BIGINT,
"penalty_kicks_saved" BIGINT,
"penalty_kicks_missed" BIGINT,
"penalty_kick_save_percentage" DOUBLE
);
Anyone who has the link will be able to view this.