By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
| Year | Company | Completed | DayofWeek | Hour | Country |
|---|---|---|---|---|---|
| 2022 | A | Y | Mon | 12 | France |
| 2019 | A | N | Tue | 14 | Germany |
| 2022 | A | Y | Thu | 13 | Italy |
| 2021 | B | Y | Sat | 16 | France |
| 2022 | B | Y | Mon | 14 | Spain |
| 2021 | B | Y | Tue | 12 | France |
| Company | Completed | Field_Name | Field_Value | Total |
|---|---|---|---|---|
| A | N | Country | Germany | 1 |
| A | Y | Country | France | 1 |
| A | Y | Country | Italy | 1 |
| A | N | DayofWeek | Tue | 1 |
| A | Y | DayofWeek | Mon | 1 |
| A | Y | DayofWeek | Thu | 1 |
| A | N | Hour | 14 | 1 |
| A | Y | Hour | 12 | 1 |
| A | Y | Hour | 13 | 1 |
| B | Y | Country | France | 2 |
| B | Y | Country | Spain | 1 |
| B | Y | DayofWeek | Mon | 1 |
| B | Y | DayofWeek | Sat | 1 |
| B | Y | DayofWeek | Tue | 1 |
| B | Y | Hour | 12 | 1 |
| B | Y | Hour | 14 | 1 |
| B | Y | Hour | 16 | 1 |