SELECT 
    CASE 
        WHEN phone IS NOT NULL THEN phone
        WHEN email IS NOT NULL THEN email
        ELSE 'No contact available' 
    END AS contact_info 
FROM contacts;