Final Exam Question 18 & 21
Dear 365datascience team:
The code provided in questions 18 + 21&22 doesn't work at all!
For question 18:
It seems that the code provided in answers dosn't work.
I got the same error code 1054 to all the answer from 1-4.
I may need your help on this one!
FOR question 21&22:
The code provided in question & answer would result in an error code 1292.
I fix this problem by simply replace the "AND" keyword with a comma (",")
in BEGIN clause, and everything would be all right!
Thank you!
Hi,
Could anyone tell me how to successfully run the code in Q18?
I still get the same error message to all the answers!
May need your help on this one.
Thank you!
best regards,
Hi CHUN!
Thanks for reaching out.
Please accept my apologies for the terribly delayed response.
Error code 1292 is encountered when there's a data type mismatch. Either you have modified a table structure, or have insterted a different type of value in some of the columns. Error code 1054 regards similar issues.
In any case, the code runs properly at my end, I just checked once again. Using AND instead of a comma do not serve the same purpose, so you may have obtained a result different from the expected one.
Can you please reboot Workbench, reconnect to the 'albums' database, and then re-run the same query to see if the output improves?
Hope this helps but please feel free to get back to us should you need further assistance. Thank you.
Best,
Martin
Submit an answer
