Advertisement
Guest User

Untitled

a guest
Aug 14th, 2019
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. SELECT COUNT(*), "CLIENT_TABLE"."AGE"
  2. FROM "CLIENT_TABLE"
  3. GROUP BY "CLIENT_TABLE"."AGE"
  4. ORDER BY "CLIENT_TABLE"."AGE"
  5.  
  6. CASE
  7. WHEN "CLIENT_TABLE"."AGE" < 18 THEN 'Under 18'
  8. WHEN "CLIENT_TABLE"."AGE" > 18 AND <= 21 THEN '19 - 21'
  9. WHEN "CLIENT_TABLE"."AGE" > 21 AND <= 35 THEN '22 - 35'
  10. END AS Age
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement