The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

Is the IFNULL and COALESCE exercise questions wrong?

Is the IFNULL and COALESCE exercise questions wrong?

Super Learner
0
Votes
1
Answer

I just went through the exercise questions of the part and found the Exercise 1 may have given a wrong instruction:
Exercise 1: Select the department number and name from the ‘departments_dup’ table and add a third column where you name the department number (‘dept_no’) as ‘dept_info’. If ‘dept_no’ does not have a value, use ‘dept_name’.
The last sentence should be “If ‘dept_name’ does not have a value, use ‘dept_name’.”

1 Answer

365 Team
0
Votes

Hi Yunfeng!
Thanks for reaching out.
Thank you for looking into the text of the Exercise in such detail.
Nevertheless, the text of the exercise is ok and doesn’t need correction at the minute.
Hope this helps.
Best,
Martin

×
Ready to Learn
Data Science?
50% OFF