peshopbs2

Untitled

Dec 7th, 2019
196
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.77 KB | None | 0 0
  1. SELECT '[0-10]' as age_group, count(*) as wizard_count
  2. FROM wizzard_deposits
  3. WHERE age BETWEEN 0 AND 10
  4. UNION
  5. SELECT '[11-20]' as age_group, count(*) as wizard_count
  6. FROM wizzard_deposits
  7. WHERE age BETWEEN 10 AND 20
  8. UNION
  9. SELECT '[21-30]' as age_group, count(*) as wizard_count
  10. FROM wizzard_deposits
  11. WHERE age BETWEEN 21 AND 30
  12. UNION
  13. SELECT '[31-40]' as age_group, count(*) as wizard_count
  14. FROM wizzard_deposits
  15. WHERE age BETWEEN 31 AND 40
  16. UNION
  17. SELECT '[41-50]' as age_group, count(*) as wizard_count
  18. FROM wizzard_deposits
  19. WHERE age BETWEEN 41 AND 50
  20. UNION
  21. SELECT '[51-60]' as age_group, count(*) as wizard_count
  22. FROM wizzard_deposits
  23. WHERE age BETWEEN 51 AND 60
  24. UNION
  25. SELECT '[61+]' as age_group, count(*) as wizard_count
  26. FROM wizzard_deposits
  27. WHERE age > 60
Advertisement
Add Comment
Please, Sign In to add comment