desafios | Desafios para prática nos fundamentos/lógica de programação

The problem is that view_stats and submission_stats have multiple rows per challenge_id.

The JOINs in the query happen before the GROUP BY and the SUM. So imagine, the result set of your query without GROUP BY and SUM.

A simplified example would be:

JObject.SelectToken expects a path to a particular token. It doesn't traverse the object to find anything with a matching name.

Looking at the object, the root object seems to have a single property with the key being the app id. That in turn has two properties, success and data, with data containing the actual info you seek.

The following works for me:

The problem isn't with the registration form. The problem is with the outer loop you use to find and click the link to the registration page.

The CSS selector div a matches 7 elements—the 4th of which is the link to the registration page. After you click the 4th link, the browser navigates to the registration page and your vista_registro() function is excecuted—successfully.

After the function completes, it returns to the loop, where you attempt to click the 5th link. Because the browser is no longer on the home page, the elements you're looping over are "stale"—that is, they no longer exist on the page (they belonged to the previous page). Hence, a StaleElementReferenceException is raised.

You likely want to stop looping over the links after you click the link to the registration page. The quickest way to do that is to add a break after your call to vista_registro().

But there's a much simpler way to find a link with some particular text in Selenium: find_element_by_link_text.

You need to execute each statement separately: