Skip to content

ELSE belongs here way more than 3 WHEN clauses, #68

@MikeFilimonov

Description

@MikeFilimonov

https://github.com/mobinni/Complete-SQL-Database-Bootcamp-Zero-to-Mastery/blob/master/SQL%20Deep%20Dive/Conditional%20Statements/answers.sql

SELECT prod_id, title, price,
CASE
WHEN price > 20 THEN 'expensive'
WHEN price <= 10 THEN 'cheap'
WHEN price BETWEEN 10 and 20 THEN 'average'
END AS "price class"
FROM products

ELSE belongs here way more than 3 WHEN clauses, e.g:

SELECT prod_id, title, price,
CASE
WHEN price > 20 THEN 'expensive'
WHEN price <= 10 THEN 'cheap'
ELSE price BETWEEN 10 and 20 THEN 'average'
END AS "price class"
FROM products

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions