{Using SELECT name, dept, COALESCE(dept, 0) AS result FROM teacher on teacher table will:
|type="()"}
- display 0 in result column for all teachers
+ display 0 in result column for all teachers without department
- do nothing - the statement is incorrect
- set dept value of all teachers to 0
- set dept value of all teachers without department to 0