dnt know if this is what u want.
Select DataID, Title, Count(*) Over (Partition by DataID) as Result
From Problem1
Order By DataID
the result is in this form
1 Names 2
1 Names 2
2 Books 1
3 Movies 1
4 Papers 1
5 Areas 4
5 Areas 4
5 Areas 4
5 Areas 4
6 Box 1