Untitled

kirzecy670

May 28th, 2025

881

Never

Add comment

Not a member of Pastebin yet? Sign Up, it unlocks many cool features!

MySQL 0.73 KB | None | 0 0

raw download clone embed print report

CASE
WHEN dateDiff('day', full_reg_datetime, date_of_action) = 0 THEN 'A. 0 Day'
WHEN dateDiff('day', full_reg_datetime, date_of_action) = 1 THEN 'B. 1 Day'
WHEN dateDiff('day', full_reg_datetime, date_of_action) <= 7 THEN 'C. 2-7 Day'
WHEN dateDiff('day', full_reg_datetime, date_of_action) <= 30 THEN 'D. 8-30 Day'
WHEN dateDiff('day', full_reg_datetime, date_of_action) <= 89 THEN 'E. 2-3 month'
WHEN dateDiff('day', full_reg_datetime, date_of_action) <= 179 THEN 'F. 4-6 month'
WHEN dateDiff('day', full_reg_datetime, date_of_action) <= 364 THEN 'G. 7-12 month'
WHEN dateDiff('day', full_reg_datetime, date_of_action) <= 729 THEN 'H. 1-2 years'
ELSE 'I. > 2 years'
END AS registration_age_group

Add Comment

Please, Sign In to add comment