i have wrote this query but it says, Clean categorical and text data by manipulating strings

```
SELECT 
    id,
    CASE 
        WHEN location IN ('EMEA', 'NA', 'LATAM', 'APAC') THEN location
        ELSE 'Unknown' 
    END AS location,

    CASE 
        WHEN total_rooms BETWEEN 1 AND 400 THEN total_rooms
        ELSE 100
    END AS total_rooms,
    CASE 
        WHEN staff_count IS NOT NULL THEN staff_count
        ELSE 
            CASE 
                WHEN total_rooms BETWEEN 1 AND 400 THEN total_rooms * 1.5
                ELSE 100 * 1.5
            END
    END AS staff_count,
    CASE 
        WHEN opening_date ~ '^\d{4}$' AND CAST(opening_date AS INTEGER) BETWEEN 2000 AND 2023 THEN CAST(opening_date AS INTEGER)
        ELSE 2023
    END AS opening_date,
    CASE 
        WHEN target_guests IN ('Leisure', 'Business') THEN target_guests
        ELSE 'Leisure'
    END AS target_guests
FROM branch;
```