framework/resources/Functional/aggregates/aggregation/sanity/q8.sql

-- limit offset in the query
select 
	b1,
	count(distinct a1) 
from 
	t1 
group by 
	b1 
order by 
	b1 limit 5 offset 1;