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

There are 4, im not the only one who got bamboozled

There seems to actaully be 4 answers, and just showing the top 3 will work. I don't know if this is intended, but the description of the problem should be changed.

Mybe that's just me but from the way the exercise is worded, I assumed it was expected to write a query that would ONLY insert the new row IF the participant was age 21 or older.
Another way to understand it would be that at any attempt that you try to add a particpant younger than 21 to the table, it would change the 'attending' column to False.

Both ways seem too hard for a Kyu 8 level, but well... the wording should really be reconsidered.

For my fellow strugglers: You need to first simply insert your row and then just print the table with the age-condition.

If I am not wrong, this is the best practice because of the following reasons:

1. It fetches only the required columns, reducing the amount of data transferred. By doing this, it also limits the possible exposure of sensitive data.
2. SQL keywords should be consistently capitalized to improve readability.

Maybe for this particular case, using '*' after the keyword 'SELECT' could lead to the same result, but I think it is good to develop the habit of just fetching the required columns by using their names and thus avoiding the possible fetching of unnecessary or sensible data.

walk in the park

I need to read one more time to understand why Mexicans and Canadias are not Americans. WTF :D America is the whole continent.

I think this kata is nice. However, some additional tests are required.

For example if I use the following code:

SELECT name, author, copies_sold FROM books WHERE copies_sold > 2000;

It actually passes all the 7 tests as for January 2024. Just adding a test with a couple of lower numbers than 2000 (let's say we have a less successful bookstore and the maximum amount of books sold per author will be let's say 100.) In this case the code above won't work.

good job!

hahaha 4 countries in table ,got issue

Read the description 30 times

Not the Best Practices definatly