Advertisement
kirzecy670

Untitled

Oct 4th, 2024
44
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.50 KB | None | 0 0
  1. SELECT
  2.   CASE
  3.     WHEN lt_week = 0 THEN 'A. < 1 week'
  4.     WHEN lt_week = 1 THEN 'B. 1 week'
  5.     WHEN lt_week <= 4 THEN 'C. < 1 month'
  6.     WHEN lt_week > 4 AND lt_week <= 8 THEN 'D. 1-2 months'
  7.     WHEN lt_week > 8 AND lt_week <= 16 THEN 'E. 2-4 months'
  8.     WHEN lt_week > 16 AND lt_week <= 32 THEN 'F. 4-8 months'
  9.     WHEN lt_week > 32 AND lt_week <= 52 THEN 'G. 8-12 months'
  10.     WHEN lt_week > 52 AND lt_week <= 104 THEN 'H. 1-2 years'
  11.     ELSE 'I. > 2 years'
  12.   END AS user_group
  13. FROM your_table_name
  14.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement