sqlite - Count items in column SQL query -

let's have table looks like,

id 2 2 3 4 5 5 5 

how like,

id count  2  2  3  1  4  1  5  3 

where count column count of each id in id column?

you want use group operation

 select id, count(id)  table  group id