---

SELECT 
    truck_number,
    cargo_weight_kg,
    fuel_consumed_l,
    ROUND(fuel_consumed_l, 0) AS fuel_rounded,
    FLOOR(fuel_consumed_l) AS fuel_floor,
    CEIL(fuel_consumed_l) AS fuel_ceil
FROM trips;

SELECT 
    t.truck_number,
    r.distance_km,
    ROUND(r.distance_km, 1) AS distance_with_one_decimal
FROM trips t
JOIN routes r ON t.route_id = r.id;

SELECT 
    truck_number,
    cargo_weight_kg,
    TRUNCATE(cargo_weight_kg, 0) AS truncated_weight
FROM trips;

SELECT 
    t.truck_number,
    r.distance_km,
    t.fuel_consumed_l,
    ROUND((t.fuel_consumed_l / r.distance_km) * 100, 2) AS fuel_per_100km,
    ABS(ROUND((t.fuel_consumed_l / r.distance_km) * 100, 2)) AS abs_fuel_per_100km
FROM trips t
JOIN routes r ON t.route_id = r.id;

SELECT 
    t.truck_number,
    r.distance_km,
    POW(r.distance_km, 2) AS distance_squared
FROM trips t
JOIN routes r ON t.route_id = r.id;

SELECT 
    truck_number,
    cargo_weight_kg,
    ROUND(SQRT(cargo_weight_kg), 2) AS sqrt_weight
FROM trips
WHERE cargo_weight_kg > 10000;

SELECT 
    truck_number,
    cargo_weight_kg,
    MOD(cargo_weight_kg, 1000) AS remainder_1000
FROM trips;

SELECT 
    truck_number,
    cargo_weight_kg,
    trip_date
FROM trips
WHERE MOD(cargo_weight_kg, 500) = 0;

SELECT 
    truck_number,
    driver_bonus_percent AS current_bonus,
    FLOOR(3 + RAND() * 16) AS random_bonus
FROM trips;

SELECT 
    truck_number,
    trip_date,
    cargo_weight_kg
FROM trips
ORDER BY RAND()
LIMIT 3;