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?

1 Like

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.

2 Likes

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

SELECT *
FROM nomom;
1 Like

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 <= '$$'
2 Likes

Hi, the following code should also work since cuisine is a text type and SQL is case insensitive.

 select * from nomnom
 where cuisine = 'japanese' and price ='$$';

What could be the problem here?

You’re telling me. I got everything else right I just didn’t know the table name was ‘nomnom’ pretty frustrating

I agree with your reasoning and came here to point out that a query that returns ‘$’ as well as ‘$$’ restaurants would be appropriate for the situation.

Does SQL parse strings in such a way that ‘$’ is valued at “LESS THAN” ‘$$’?

My first thought was that it wouldn’t, but now I’m not sure.