-- Calculate the duration in months

DATEDIFF('day', BLOCK_TIMESTAMP, UNLOCK_TIMESTAMP) AS DURATION_DAYS

FROM

crosschain.olas.ez_olas_locking

where

UNLOCK_TIMESTAMP is not null

)

CASE

WHEN DURATION_DAYS BETWEEN 1 AND 30 THEN '1. 1-30 days'

WHEN DURATION_DAYS BETWEEN 31 AND 60 THEN '2. 31-60 days'

WHEN DURATION_DAYS BETWEEN 61 AND 90 THEN '3. 61-90 days'

WHEN DURATION_DAYS BETWEEN 91 AND 180 THEN '4. 91-180 days'

WHEN DURATION_DAYS BETWEEN 181 AND 365 THEN '5. 181-365 days'

WHEN DURATION_DAYS BETWEEN 366 AND 730 THEN '6. 366-730 days'

WHEN DURATION_DAYS BETWEEN 731 AND 1460 THEN '7. 731-1460 days'

ELSE '8. Out of range'

END AS DURATION_BUCKET,

COUNT(*) AS COUNT

from duration

group by DURATION_BUCKET

order by DURATION_BUCKET