the requirement is to query the latest 3 transactions of each customer. The sql is similar to the following:

select * 
  from (
    select , 
           rank() over(partition by  order by ) as ranking 
      from ) 
 where ranking > 3

how to use stream to sort within a group and take the first few items