SQL: TABLE Transformation


#1

SQL Answer:

SELECT REPLACE(ingredients,‘enriched_’,’ ') as item_ingredients
FROM baked_goods;

My answer:

SELECT id, REPLACE(ingredients,‘enriched_flour’,‘flour’) as ingredients
from baked_goods;

What is the difference between this two method? I do not understand why I am wrong?
Thanks a lot in advance :slight_smile:


#2

The lesson checker may not be set up to accept both solutions. They are both correct.


#3

Thank you :slight_smile:
Does anyone have more suggestions on learning SQL, I will be finishing all three SQL courses that Codecademy offer.

Thanks again,


#4

You’re welcome.

All I can suggest is where I would start… Search SQL tutorials. Only reason I say that is because I don’t have any suggestions, but don’t want you to wait for responses on this topic. Dig around in the meantime and report back anything interesting that you might find. By then, there may be other responses.


#5

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