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

Follow this topic

Yunfeng Zhao

Last answered:

26 Apr 2020

Posted on:

23 Apr 2020

Is the IFNULL and COALESCE exercise questions wrong?

1 answers ( 0 marked as helpful)

Martin Ganchev

Instructor

Posted on:

26 Apr 2020

Is the IFNULL and COALESCE exercise questions wrong?

Submit an answer