FAQ: CRUD I: Finding Documents - Comparison Operators: $gt and $lt

This community-built FAQ covers the “Comparison Operators: $gt and $lt” exercise from the lesson “CRUD I: Finding Documents”.

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

[Beta] Learn MongoDB

FAQs on the exercise Comparison Operators: $gt and $lt

There are currently no frequently asked questions associated with this exercise – that’s where you come in! You can contribute to this section by offering your own questions, answers, or clarifications on this exercise. Ask or answer a question by clicking reply (reply) below.

If you’ve had an “aha” moment about the concepts, formatting, syntax, or anything else with this exercise, consider sharing those insights! Teaching others and answering their questions is one of the best ways to learn and stay sharp.

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

Ask or answer a question about this exercise by clicking reply (reply) below!
You can also find further discussion and get answers to your questions over in Language Help.

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

Need broader help or resources? Head to Language Help and Tips and Resources. If you are wanting feedback or inspiration for a project, check out Projects.

Looking for motivation to keep learning? Join our wider discussions in Community

Learn more about how to use this guide.

Found a bug? Report it online, or post in Bug Reporting

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!

Hello All,

I’m confused as to why the correct response, [codebyte]db.listingsAndReviews.find({ “address.street”: { $lte: “C” }})[/codebyte], would return documents containing street names starting with the letter, “C,” and containing more than one character. My reading of this code suggests that this should return only those documents containing the exact street name, “C,” along with those starting with the letters, “A,” through, “b.”

Question 2 wants us to, “find all the restaurants where the name of the street where the restaurant is located starts with the letter "C" or any alphanumeric character that comes before it.” So, why does the above code work when the street name is, “Coney Island Avenue?”

Why isn’t, [codebyte]db.listingsAndReviews.find({ “address.street”: { $lt: “D” }})[/codebyte], the correct answer?

Try running the queries again.

The "5 Star Village Cafe" whose street address is "Coney Island Avenue" is NOT INCLUDED in the less than or equal to "C" query. You can confirm it by running the query:

db.listingsAndReviews.find({ "address.street": { $lte: "C" } }, { name: 1 })

The restaurant doesn’t appear in the results.

You’re right, I’m now finding that the document containing “street: Coney Island Avenue” is not included in the results, as makes sense given the code.

So, given that the module question and, ‘correct,’ answer are as follows…

Q: Query the listingsAndReviews collection again, this time to find all the restaurants where the name of the street where the restaurant is located starts with the letter "C" or any alphanumeric character that comes before it.

A: db.listingsAndReviews.find({ “address.street”: { $lte: “C” }})

… is the module wrong, or am I still missing something?

You can report it via the “Get Unstuck” drop-down menu in the exercise. From the “Bugs” option, you can select “There’s an issue with the content” and describe your observation and your proposed correction. The course authors may then correct the phrasing in the instructions.