In Google Sheets, I'm trying to write a Query (not a stand alone Pivot Table nor script), which groups by a calculated value based on an if/then statement.

**Here's my sample data:**

```
Name    Days
Bob     0
Ed      1
Frank   2
Joey    4
Deluth  7
Henry   12

```

Grouping by column B is fairly straight forward: 

```
=QUERY(A1:B7,"SELECT B, COUNT(B) GROUP BY B")

```

which outputs:

```
Days    count
0       1
1       1
2       1
4       1
7       1
12      1

```

But what I'm trying to do is group the days in to specific buckets. The buckets and desired output would be this **desired output**:

```
Days    count
0       1
1       1
2-5     2
6-9     1
10+     1

```

So it's almost an "if 0 then '0', if 1 then '1', if >1 AND <=5 then '2-5', etc., with a Group By at the end? How would this be written in QUERY format?