select with ties p, sum(case when o> 2  then  1  else  0 ) as resalt
from myTabl
group by p
order by  2  asc
union all
select with ties p, sum(case when o> 2  then  1  else  0 ) as resalt
from myTabl
group by p
order by  2  desc

DIMENSION anMax ( 1 )
DIMENSION anMin ( 1 )
store  0  to anMax, aMin
select top  1  sum(iif(o< 3 , 1 , 0 ))  ;
FROM student ;
GROUP BY p ;
ordere by  1  desc ;
into array anMax
select top  1  sum(iif(o< 3 , 1 , 0 ))  ;
FROM student ;
GROUP BY p ;
ordere by  1  asc ;
into array anMin
select p,sum(iif(o< 3 , 1 , 0 )) as Upal ;
from student ;
group by p ;
having sum(iif(o< 3 , 1 , 0 ))=anMin( 1 ) or sum(iif(o< 3 , 1 , 0 ))=anMax( 1 ) ;
into cursor cMyResalt
release anMax
release anMin
select cMyResalt
brows
*то что заказывал