SQL合并并将两个布尔值转换为字符串列

SELECT 
    CASE 
        WHEN bool_value1 = true AND bool_value2 = true THEN 'Both true'
        WHEN bool_value1 = true AND bool_value2 = false THEN 'First true, second false'
        WHEN bool_value1 = false AND bool_value2 = true THEN 'First false, second true'
        ELSE 'Both false'
    END AS merged_string
FROM your_table;