hi i don't want to insert
i just need to know in my table
who are the id that have the most record depending on their ID and date.
each id is nunique and its for one person
but sometimes this id is repeated depending on the date
so on date 1 i have id 1
on date2 i have id1
on date 3 i have id2
so the id have many record on different times
i need to know how many time i have id1, and id2 etc...
example : id 1 have 45 times recorder
that all