FAQ: Code Challenge: Queries - Code Challenge 3

This community-built FAQ covers the “Code Challenge 3” exercise from the lesson “Code Challenge: Queries”.

Paths and Courses
This exercise can be found in the following Codecademy content:

Web Development
Data Science

FAQs on the exercise Code Challenge 3

Join the Discussion. Help a fellow learner on their journey.

Ask or answer a question about this exercise by clicking reply (reply) below!

Agree with a comment or answer? Like (like) to up-vote the contribution!

Need broader help or resources? Head here.

Looking for motivation to keep learning? Join our wider discussions.

Learn more about how to use this guide.

Found a bug? Report it!

Have a question about your account or billing? Reach out to our customer support team!

None of the above? Find out where to ask other questions here!

I am still confused with how the AND statement works. I tried the following code, it didn’t work-

SELECT name, gender, number
FROM babies
WHERE year = 1880
AND ORDER BY number DESC
AND LIMIT 10;

What am I getting wrong? Is AND only to be used when you’re doing operations on two different columns ?

you don’t need to use AND in this case. AND is used when you’re joining multiple conditions, like: where… and… and…

I’m not fully understanding what GROUP BY does.

In the first query I leave out ‘GROUP BY name’ and the second one I include it. I’m not sure why there is a difference in query results. For instance, why is ‘John’ and ‘William’ not included in the second query results?

that´s an interesting question. i would have also expected the same result.
nevertheless name is the primary key, and grouping by a primary key does not really make sense, innit?