select e.team_name,e.region,b.match_date,b.opponent,b.kills,b.deaths,b.kda_ratio,b.result from esports_teams e join lateral ( select match_date,opponent,kills,deaths,kda_ratio,result from( select match_date,opponent,kills,deaths,round(kills/deaths,2) as kda_ratio, case when is_win =1 then '胜' else '...