面试题sql

查询书的价格10到20 之前显示10to20 没有显示unknown

 

CREATE TABLE book(
price INT,
NAME VARCHAR(20)
)

SELECT NAME AS '名字',price,(CASE WHEN price>=10 AND price<=20 THEN '10 to 20' ELSE 'unknow' END)AS '结果'

FROM book