I have a table with some records about fuel consumption. The important columns in the table are: `CONSUME_DATE_FROM` and `CONSUM_DATE_TO`.

I want to calculate average fuel consumption per cars on a monthly basis but some rows are not in the same month. For example some have a three month difference between them and the total of gas per litre is aggregated in a single row.

Now I should find records that have difference more than a month between `CONSUME_DATE_FROM` and `CONSUM_DATE_TO`, and duplicate them in current or second table per count of month and divide the total gas per litre between related rows.

I've this table with the following data:

```
ID    VehicleId CONSUME_DATE_FROM  CONSUM_DATE_TO   GAS_PER_LITER
1      100      2018-10-25         2018-12-01           600         
2      101      2018-07-19         2018-07-24           100 
3      102      2018-12-31         2019-01-01           400
4      103      2018-03-29         2018-05-29           200
5      104      2018-02-05         2018-02-09           50

```

The expected output table should be as below

```
ID    VehicleId CONSUME_DATE_FROM  CONSUM_DATE_TO   GAS_PER_LITER
1      100      2018-10-25          2018-12-01      200         
1      100      2018-10-25          2018-12-01      200     
1      100      2018-10-25          2018-12-01      200     
2      101      2018-07-19          2018-07-24      100 
3      102      2018-12-31          2019-01-01      200
3      102      2018-12-31          2019-01-01      200
4      103      2018-03-29          2018-05-29      66.66
4      103      2018-03-29          2018-05-29      66.66
4      103      2018-03-29          2018-05-29      66.66
5      104      2018-02-05          2018-02-09      50

```

Or as below

```
ID VehicleId CONSUME_DATE_FROM CONSUM_DATE_TO  GAS_PER_LITER DATE_RELOAD_GAS        
    1      100      2018-10-25       2018-12-01     200        2018-10-01       
    1      100      2018-10-25       2018-12-01     200        2018-11-01           
    1      100      2018-10-25       2018-12-01     200        2018-12-01           
    2      101      2018-07-19       2018-07-24     100        2018-07-01
    3      102      2018-12-31       2019-01-01     200        2018-12-01
    3      102      2018-12-31       2019-01-01     200        2019-01-01
    4      103      2018-03-29       2018-05-29     66.66      2018-03-01
    4      103      2018-03-29       2018-05-29     66.66      2018-04-01
    4      103      2018-03-29       2018-05-29     66.66      2018-05-01
    5      104      2018-02-05       2018-02-09     50         2018-02-01

```

Can someone please help me out with this query?

I'm using oracle database