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'."

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

back

Follow this topic

Yunfeng Zhao

Last answered:

April 26, 2020

Posted on:

April 23, 2020

Is the IFNULL and COALESCE exercise questions wrong?

1 answers ( 0 marked as helpful)

Martin Ganchev

Posted on:

April 26, 2020

Submit an answer

Content