How to group a selection?

Question

SQL

Hello.
I have a likes table, in it:
`id` - just to be.
`user_id` - the person who liked it.
`peer_id` is the person `user_id` likes.

`user_id` can like `peer_id` at least 1000 times, and so I would like to do this: And so that user_id is not duplicated, but written once. But I don't understand how to do it with GROUP BY, any help would be very much appreciated.
SELECT * FROM `users` WHERE `peer_id`=1

Answer 1

SELECT `user_id`, COUNT(`peer_id`) FROM `users` WHERE `peer_id`=1 GROUP BY `user_id`