I want to create a sql query to split a single column value into multiple rows like: 

```
SELECT ID, PRODUCT_COUNT FROM MERCHANT WHERE ID = 3050

ID          PRODUCT_COUNT
----------- -------------
3050        591

```

Based on this result, I want 6 rows as follows:

```
ID      RANGE    
3050    0-100
3050    101-200
3050    201-300
3050    301-400
3050    401-500
3050    501-591

```

How can I acheive this in a query ?