>Bargain''''
 WHEN price BETWEEN 10 and 20 THEN ''''Average''''
ELSE ''''Gift to impress relatives''''
END AS Range,
Title
FROM titles
GROUP BY
CASE
WHEN price IS NULL THEN ''''Unpriced''''
WHEN price < 10 THEN ''''Bargain''''
WHEN price BETWEEN 10 and 20 THEN ''''Average''''
ELSE ''''Gift to impress relatives''''
END,
Title
ORDER BY
CASE
WHEN price IS NULL THEN ''''Unpriced''''
WHEN price < 10 THEN ''''Bargain''''
WHEN price BETWEEN 10 and 20 THEN ''''上一页 [1] [2] [3] [4] 下一页 |
