SELECT reservation_id, reservation_date,
    CASE
        WHEN DAYOFWEEK(reservation_date) = 6 OR DAYOFWEEK(reservation_date) = 7 THEN 'High Rate'
        ELSE 'Regular Rate'
    END AS RateType
FROM reservations;