Flag top quartile customers

WITH bucketed AS (
  SELECT customer_id,
         lifetime_value,
         NTILE(4) OVER (ORDER BY lifetime_value DESC) AS quartile
  FROM customers
)
SELECT customer_id,
       lifetime_value,
       CASE WHEN quartile = 1 THEN 'top_quartile' ELSE 'other' END AS segment
FROM bucketed;