By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
(No column name) |
---|
Microsoft SQL Server 2016 (SP2-CU12) (KB4536648) - 13.0.5698.0 (X64) Feb 15 2020 01:47:30 Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor) |
8 rows affected
id | equipo | goles | temporada |
---|---|---|---|
1 | A | 0 | 3 |
2 | A | 0 | 2 |
3 | A | 0 | 1 |
4 | A | 5 | 4 |
5 | B | 0 | 1 |
6 | B | 3 | 3 |
7 | B | 0 | 2 |
8 | B | 0 | 4 |
equipo | ConteoPerdidos |
---|---|
A | 3 |