I am new to Databricks and SQL. My CASE statement is not working and I cannot figure out why. Below is my code and the error message I'm receiving. Grateful for any and all suggestions. I'm trying to put yrs_to_mat into buckets.

am777
New Contributor

‎11-16-2022 07:04 PM 

SELECT *, yrs_to_mat,
 CASE 
      WHEN < 3 THEN "under3"
      WHEN => 3 AND < 5 THEN "3to5"
      WHEN => 5 AND < 10 THEN "5to10"
      WHEN => 10 AND < 15 THEN "10to15"
      WHEN => 15 THEN "over15"
      ELSE null END AS maturity_bucket
FROM matyrs; 
Error in SQL statement: ParseException: 
[PARSE_SYNTAX_ERROR] Syntax error at or near 'THEN'(line 3, pos 15)
 
== SQL ==
SELECT *, yrs_to_mat,
 CASE 
      WHEN < 3 THEN "under3"
---------------^^^
      WHEN => 3 AND < 5 THEN "3to5"
      WHEN => 5 AND < 10 THEN "5to10"
      WHEN => 10 AND < 15 THEN "10to15"
      WHEN => 15 THEN "over15"
      ELSE null END AS maturity_bucket
FROM matyrs

Labels:
0 Kudos