SQL为group子句获得最高的重复值

I want a SQL query which should tell me that for each ID which value repeated most of time. For example lets take the following table:I want a SQL query which should tell me that fo