Help me in solving SQW45 problem

help
,
1

My issue

SELECT
r.lane_id,
n.origin,
n.destination,
r.revenue,
CASE
WHEN r.revenue >= 25000 THEN ‘High revenue’
WHEN r.revenue BETWEEN 18000 AND 24999 THEN ‘Medium revenue’
ELSE ‘Low revenue’
END AS revenue_cat
FROM
Revenue r
JOIN
Network n ON r.lane_id = n.connection_id ;
this is my code but i am unable to get the expected output

My code

SELECT 
    r.lane_id,
    n.origin,
    n.destination,
    r.revenue,
    CASE
        WHEN r.revenue >= 25000 THEN 'High revenue'
        WHEN r.revenue BETWEEN 18000 AND 24999 THEN 'Medium revenue'
        ELSE 'Low revenue'
    END AS revenue_cat
FROM
    Revenue r
JOIN
    Network n ON r.lane_id = n.connection_id ;

Learning course: Learn Data Analytics using SQL and Python
Problem Link: CodeChef: Practical coding for everyone

2

SELECT
r.lane_id,
r.origin,
r.destination,
r.revenue,
CASE
WHEN r.revenue >= 25000 THEN ‘High revenue’
WHEN r.revenue BETWEEN 18000 AND 24999 THEN ‘Medium revenue’
ELSE ‘Low revenue’
END AS revenue_cat
FROM
Revenue r;