Exercise: First Available Contact
Get first available: phone, email, or 'N/A'.
Solution
sql
1SELECT name,
2 COALESCE(phone, email, 'N/A') AS contact
3FROM students;
Get first available: phone, email, or 'N/A'.
1SELECT name,
2 COALESCE(phone, email, 'N/A') AS contact
3FROM students;