FAQ: Code Challenge: Queries - Code Challenge 4

This community-built FAQ covers the “Code Challenge 4” 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 4

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!

Japanese and price - I didn’t know it was based on $$ not an actual number - how was I supposed to know this?

One way to go is

SELECT DISTINCT price
FROM nomnom

This will return the unique values for the price column. Then you’ll learn that this column takes the dollar signs as its values.

1 Like

I just ran the usual query to get a look at the data before I wrote the conditions:

SELECT *
FROM nomom;

This one was kind of misleading because it mentions that you’re on a budget, but the conditions in your code that you need to meet are

WHERE cuisine = 'Japanese'
AND price = '$$'

It should also accept:

WHERE cuisine = 'Japanese'
AND price <= '$$'
1 Like