By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
(No column name) |
---|
Microsoft SQL Server 2019 (RTM-CU6) (KB4563110) - 15.0.4053.23 (X64) Jul 25 2020 11:26:55 Copyright (C) 2019 Microsoft Corporation Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor) |
15 rows affected
yyyymmdd | period | country | cat1 | cat2 | cat3 | score |
---|---|---|---|---|---|---|
2019-12-01 | A | US | Sports | Cycle | long | 33 |
2019-12-01 | A | US | Sports | Cycle | Short | 35 |
2019-12-01 | A | US | Sports | Running | long | 28 |
2019-12-01 | A | US | Sports | Running | short | 29 |
2019-12-01 | A | US | Arts | null | null | null |
2019-12-02 | A | US | Sports | Cycle | long | 43 |
2019-12-02 | A | US | Sports | Cycle | Short | 44 |
2019-12-02 | A | US | Sports | Running | long | 35 |
2019-12-02 | A | US | Sports | Running | short | 37 |
2019-12-02 | A | US | Arts | null | null | null |
2020-12-01 | B | US | Sports | Cycle | long | 33 |
2020-12-01 | B | US | Sports | Cycle | Short | 35 |
2020-12-01 | B | US | Sports | Running | long | 28 |
2020-12-01 | B | US | Sports | Running | short | 29 |
2020-12-01 | B | US | Arts | null | null | null |
yyyymmdd | period | country | cat1 | cat2 | cat3 | score | score_day1 |
---|---|---|---|---|---|---|---|
2019-12-01 | A | US | Sports | Cycle | long | 33 | 33 |
2019-12-01 | A | US | Sports | Cycle | Short | 35 | 35 |
2019-12-01 | A | US | Sports | Running | long | 28 | 28 |
2019-12-01 | A | US | Sports | Running | short | 29 | 29 |
2019-12-01 | A | US | Arts | null | null | null | null |
2019-12-02 | A | US | Sports | Cycle | long | 43 | 33 |
2019-12-02 | A | US | Sports | Cycle | Short | 44 | 35 |
2019-12-02 | A | US | Sports | Running | long | 35 | 28 |
2019-12-02 | A | US | Sports | Running | short | 37 | 29 |
2019-12-02 | A | US | Arts | null | null | null | null |
2020-12-01 | B | US | Sports | Cycle | long | 33 | 33 |
2020-12-01 | B | US | Sports | Cycle | Short | 35 | 35 |
2020-12-01 | B | US | Sports | Running | long | 28 | 28 |
2020-12-01 | B | US | Sports | Running | short | 29 | 29 |
2020-12-01 | B | US | Arts | null | null | null | null |