group by range

• QQ-485619

  Ten Centuries

  Points: 1195

  More actions

  October 28, 2014 at 10:39 pm

  #300521

  I have a list people with age:

  Name Age Gender

  John 12 M

  Sara 15 F

  Tom 16 M

  Tim 13 M

  Joshua 19 M

  I need to count the number of people who is between 10-14 and 15 to 21 and by gender

  How Can I do.

  Thanks,

  Jian

• pietlinden

  SSC Guru

  Points: 63503

  More actions

  October 28, 2014 at 11:02 pm

  #1755405

  use a CASE statement to group the age ranges into two groups, then summarize on that. What have you tried so far?