---select rank 2,3 user that generates the most sales
select customer_id, sum(sales) as total
from orders_tab as ot 
group by customer_id 
order by total desc
offset 1 limit 2 -- skip row 1 and limit by 2