The second query is already written, the only thing you should do is complete the insert query.

INSERT --Your code here

SELECT * FROM participants;

I fail to see what's confusing there.

Bumping, because 3 years later it still hasn't been updated xD

Yes! It was a great refreser for the WHERE NOT for me too :)

So your statement does produce the correct results, they just aren't in the expected order, which isn't stated by the kata. I think the kata expects you to use only one SELECT statement. Because of the way your statement works, it will produce a different order of values than if you just did it in one select statement (specifically because of the two GROUP BY clauses, I think)

In any case, try again with a single SELECT statement. Not only is it possible, it's more efficient.

You could try using only one SELECT.