Chapter 4: Advanced CRUD Operations - Lab 2: Logic Operators

Hi!

I would like to suggest a change on Problem utterance.

I failed my submissions because I considered that founded_month was a text value (October).

  • FROM:

… [or] were founded in the month of October
[and] also either have the social category_code [or] web category_code?

  • TO:

… [or] were founded in the month 10
[and] also either have the social category_code [or] web category_code?

In real life requirements are not always straightforward. That is why you have to know your data. Schema analysis with Compass is a great tool to do that.

3 Likes

Yes @steevej

I’ll be more careful with the data :+1:

I proposed this change to avoid that other people make the same mistake as I did.

Hi, @fthomasvp,

We appreciate your suggestion, but as @steevej mentioned we encourage our learners to look and understand the data that they are writing queries for. In that way, they will have both the good practices of querying as well as how to write conditional queries.!!

Please let us know if you have any additional queries.

Thank you,
Kushagra

1 Like

This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.