SELECT c.checkin_id ,

    c.user_id ,

    c.likes ,

    (

    SELECT ROUND(AVG(likes),1) FROM checkins c 

    WHERE user_id = c.user_id

    ) AS avg_likes_user

  FROM checkins c;