How to spread the average between two intervals in oracle?

@arnoldo.moen 

To spread the average between two intervals in Oracle, you can use the following SQL query:

1
2

SELECT (interval_start + interval_end) / 2 AS average_interval
FROM your_table_name;

In this query, replace your_table_name with the name of your table and interval_start and interval_end with the columns that represent the starting and ending points of your interval. This query will calculate the average of the intervals for each row in the table.