By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
2 rows affected
team | opposition | Shots | Shots_on_Target | Goals | Time | Day | oppo_shots | Oppo_Shots_on_Target | opp_Goals |
---|---|---|---|---|---|---|---|---|---|
Brazil | England | 6 | 3 | 1 | 1200 | Saturday | 3 | 1 | 0 |
England | Brazil | 3 | 1 | 0 | 1200 | Saturday | 6 | 3 | 1 |