title: Teradata Top-middle-bottom customers
body: <p>I have a customer data set with the Customer ID and customer Spend. I need to split the customer dataset into 3 groups based on the customer send(high spend customers, Medium spend custs, low spend custs). I tried using RANK and Partitio by but i wasn't able to give the number of groups(3). Is there any other way I can do this with Teradata.
  If there are 9 customers, I need to first sort them all by the amount spent and then divide them into 3 groups and count how many customers are there under each group(3). Also determine the Min and max values of the amount spent under each group</p>
  
  <p>Say, Cust F,G,I spent between $9 to $ 12 and are under high-spend
   Cust A,B,D spent between $4 to $8 and are in the medium spend
  Custs C,E,H spent between $1-$3 and are under low spend</p>
  
  <p>The output should be 
  GROUP(1,2,3) ; # Custs(3,3,3); Min_Spend($9,$4,$1); MAX_SPEND($12,$8,$3)</p>