SQL Query to merge range records from an oracle database

Job ID: 35287717

Budget: $10 – $30 USD

I'm looking to write an oracle sql query that would bring from, the challenge is to be able to run across 10,000 records to consolidate the ranges.

Attached are tables for the before and after.

Deliverables, SQL query (oracle)