Here below is a data table:

We want to count the number of people in each of the following score segments respectively: below 50, 50-60, 60-70, 70-80, 80-90 and above 90.

=spl("=E(?1).groups(if(Score<50:""<50"",Score>=50 && Score<60:""50-60"",Score>=60 && Score<70:""60-70"",Score>=70 && Score<80:""70-80"",Score>=80 && Score<90:""80-90"";"">=90""):Score;count(1):Num)",A1:C25)

https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1656816073028
https://c.scudata.com/article/1656898145210