145. Practice - IFNULL

Exercise: Default Email

Replace NULL email with 'No Email'.

Solution

1SELECT name, IFNULL(email, 'No Email') AS email
2FROM students;