By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 12
CREATE INDEX
| the_date | company | col3 |
|---|---|---|
| 2004-01-01 | A | 5 |
| 2004-01-02 | A | 5 |
| 2004-01-02 | B | 7 |
| 2004-01-03 | A | 6 |
| 2004-01-03 | B | 7 |
| 2004-01-03 | C | 9 |
| 2004-01-04 | A | 6 |
| 2004-01-04 | B | 7 |
| 2004-01-04 | C | 9 |
SELECT 9