CREATE TABLE Participant (
id int,
name varchar(100),
gender varchar(100),
age int,
user_id int
);
INSERT INTO Participant (id, name, gender, age, user_id)
VALUES
(1, 'nameA', 'male', 8, 1),
(2, 'nameA', 'female', 10, 1),
(3, 'nameA', 'male', 8, 1),
(4, 'nameA', 'female', 8, 1);
SELECT * FROM Participant;