bp Interview Question

Find 5th highest revenue for region.

Interview Answer

Anonymous

Sep 22, 2025

assume got region table with region_id, revenue column select region_id, sum(revenue) as total_revenue from region group by region_id order by sum(revenue) asc limit 5;