I'm seeking some help with this task. I've done a few searches but can't find anything I need.

I have 180 guests coming to an event. I want the guests to be randomly assigned to one of 25 possible tables, however I want to make sure that there are only 8 people to table.

I've tried RANDBETWEEN however I can't think of a way to cap the number of assigned numbers to 8.

Any ideas are appreciated.