How can i acive the following:

Product, From, To

Pizza, 1, 3

Burger , 1, 5

Hotdog, 2, 2

Result:

[somecolumn], Occurs

1, 2

2, 3

3, 2

4, 1

5, 1

I want to do this without a function or procedure, just a "simple" s

Which version of SQL Server do you have?

And, if the answer is SQL 2008 or earlier, what volumes are we talking about?