Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT '[0-10]' as age_group, count(*) as wizard_count
- FROM wizzard_deposits
- WHERE age BETWEEN 0 AND 10
- UNION
- SELECT '[11-20]' as age_group, count(*) as wizard_count
- FROM wizzard_deposits
- WHERE age BETWEEN 10 AND 20
- UNION
- SELECT '[21-30]' as age_group, count(*) as wizard_count
- FROM wizzard_deposits
- WHERE age BETWEEN 21 AND 30
- UNION
- SELECT '[31-40]' as age_group, count(*) as wizard_count
- FROM wizzard_deposits
- WHERE age BETWEEN 31 AND 40
- UNION
- SELECT '[41-50]' as age_group, count(*) as wizard_count
- FROM wizzard_deposits
- WHERE age BETWEEN 41 AND 50
- UNION
- SELECT '[51-60]' as age_group, count(*) as wizard_count
- FROM wizzard_deposits
- WHERE age BETWEEN 51 AND 60
- UNION
- SELECT '[61+]' as age_group, count(*) as wizard_count
- FROM wizzard_deposits
- WHERE age > 60
Advertisement
Add Comment
Please, Sign In to add comment