8/9 - Why "id" need to be removed


#1

https://www.codecademy.com/en/courses/sql-table-transformation/lessons/date-number-string-functions/exercises/strings-ii

Just want to understand why I need to remove 'id' out of the query, it is not clear for me.

My Original query was like this:

SELECT id, REPLACE(ingredients, 'enriched_flour', 'flour') AS item_ingredients
FROM baked_goods;



But the one it works was the below query:

SELECT REPLACE(ingredients, 'enriched_flour', 'flour') AS item_ingredients
FROM baked_goods;

Thanks for the help!


#2

It is not expected by the SCT, but it does not have to be removed for any other reason.


#3

By SCT you mean like System Configuration Tool? your talking about the interface where we enter our code?


#4

Submission Correctness Test, which is built into the lesson. It is not part of SQL.


#5

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