Column Actions

select 'Arsenal' home_team, 1 home_team_score, 'Manchester City' away_team, 0 away_team_score, 
       'COMPLETED' game_state, 'FT' status_label, null game_url, 
       'Martinelli (86'')' home_team_scorers, null away_team_scorers, 
       :P37_SHOW_SCORERS show_scorers, null result from dual union all
select 'Brighton' home_team, 2 home_team_score, 'Liverpool' away_team, 2 away_team_score, 
       'LIVE' game_state, '81 mins' status_label, '#' game_url, 
       'Adingra (20'')|Dunk (78'')' home_team_scorers, 'Salah (40'', 45''+1 pen)' away_team_scorers, 
       :P37_SHOW_SCORERS show_scorers, null result from dual union all
select 'West Ham' home_team, null home_team_score, 'Newcastle' away_team, null away_team_score, 
       null game_state, '19:45' status_label, '#' game_url, 
       null home_team_scorers, null away_team_scorers, 
       :P37_SHOW_SCORERS show_scorers, null result from dual

with match_score as (
   select 1 game_id,
         'CSKA Sofia' home_team, 3 home_team_score,
         'Plamen Mushkov (15'', 62'', 70'')' home_team_scorers,
         'Levski Sofia' away_team, 0 away_team_score, 
         null away_team_scorers,
         'COMPLETED' game_state, 'FT' status_label, null game_url, /*:P37_SHOW_SCORERS*/ 'Y' show_scorers
   from dual ),

match_facts as (
   select 1 game_id, 'Possession'      fact_name, 38 home_team_val, 62 away_team_val, 'Y' is_percentage from dual union all
   select 1 game_id, 'Shots'           fact_name, 19 home_team_val, 11 away_team_val, 'N' is_percentage from dual union all
   select 1 game_id, 'Shots on Target' fact_name,  9 home_team_val,  3 away_team_val, 'N' is_percentage from dual union all
   select 1 game_id, 'Corners'         fact_name,  1 home_team_val,  3 away_team_val, 'N' is_percentage from dual union all
   select 1 game_id, 'Fouls'           fact_name, 19 home_team_val, 21 away_team_val, 'N' is_percentage from dual
)

select f.game_id, f.fact_name, f.is_percentage,
       f.home_team_val, round(f.home_team_val/(f.home_team_val+f.away_team_val)*100,2) home_team_val_perc,
       f.away_team_val, round(f.away_team_val/(f.home_team_val+f.away_team_val)*100,2) away_team_val_perc,
       s.home_team, s.home_team_score, s.home_team_scorers, 
       s.away_team, s.away_team_score, s.away_team_scorers,
       s.game_state, s.status_label, s.game_url, s.show_scorers
from match_facts f
join match_score s
   on f.game_id = s.game_id