```
create table #Task (ID int, Name varchar(1), Occurrence int)

insert into #Task values (1, 'A', 2)
insert into #Task values (2, 'B', 3)
insert into #Task values (3, 'C', 1)
insert into #Task values (4, 'D', 2)

select * from #Task
Go

```

[![enter image description here](https://i.stack.imgur.com/2bfI7.jpg)](https://i.stack.imgur.com/2bfI7.jpg)