By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
9 rows affected
VEHICLE_ID | EMP_ID | DATE | LAST_6M_UNIQ_VEHICLE_COUNT | LAST_6M_VEHICLE_COUNT |
---|---|---|---|---|
2 | 1 | 31-JAN-20 | 2 | 2 |
3 | 1 | 31-JAN-20 | 2 | 2 |
2 | 1 | 29-FEB-20 | 2 | 3 |
2 | 1 | 31-MAR-20 | 2 | 4 |
2 | 1 | 30-APR-20 | 2 | 5 |
2 | 1 | 31-MAY-20 | 2 | 6 |
1 | 1 | 30-JUN-20 | 3 | 7 |
2 | 1 | 31-JUL-20 | 3 | 8 |
1 | 1 | 31-AUG-20 | 2 | 7 |