select *
from (
select boltkod, datum, statusz, row_number() over (partition by boltkod order by datum desc) sorszam
from latogatasok
)
where sorszam <= 4
order by boltkod, sorszam
/