Avg level view

CREATE OR REPLACE VIEW skill_avg_level_view AS
          SELECT
             s.id AS skill_id,
             COALESCE(ROUND(AVG(u.level), 2), 0) AS avg_level,
             COUNT(u.user_id) AS user_count,
             GROUP_CONCAT(DISTINCT u.user_id ORDER BY u.user_id) AS user_ids
          FROM
             skill AS s
             LEFT JOIN
                user_skills AS u
                ON s.id = u.skill_id
          GROUP BY
             s.id