Three students and three sqlusers are randomly selected from each SQL statement.

Three students and three sqlusers are randomly selected from each SQL statement.

The school has one, two, three .... To Class 10.
Suppose there are 30 students in each class. Zhang, Li, Liu, and Su
Currently, student, class, and name fields exist. Class indicates the class, and name indicates the name of each student.
Three students are required to be extracted from each class for cleaning.

Write such SQL statement.

Select name from (select (row_number () over (partition by class order by checksum (newid () id, * from student) a where id <= 3