By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 6
| time | metric_a | metric_b | value |
|---|---|---|---|
| B | A | A | 1 |
| B | A | B | 2 |
| B | A | C | 1 |
SELECT 3
CREATE TABLE
INSERT 0 6
| time | metric_a | metric_b | value |
|---|---|---|---|
| B | A | A | 1 |
| B | A | B | 2 |
| B | A | C | 1 |
SELECT 3