Category "group-concat"

is there a way to extract duplicated row value in sql as the key/grouping value?

I have following two tables users id | name 1 | john 2 | ada events id | content | userId 1 | 'applied' | 1 2 | 'interviewed| 1 What would be the