By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
STORE | DATE | TIME | RESPONSE | ROW_NUMBER_BY_STORE |
---|---|---|---|---|
Store1 | 15/11/2019 00:00:00 | 15:37:40 | 1 | 1 |
Store1 | 15/11/2019 00:00:00 | 15:37:40 | 1 | 2 |
Store3 | 17/11/2019 00:00:00 | 16:55:12 | 2 | 3 |
Store3 | 17/11/2019 00:00:00 | 15:37:12 | 2 | 4 |