queries for score_group update

update_score_group.sql

-- 1. The following query populates the user_ids with a comma-separated value of some user_ids (some is specified inside the substring_index function) on survived score_group

update score_group set user_ids=(select substring_index(GROUP_CONCAT(user_id SEPARATOR ','), ',', 3) as expecting_ids from user_leaderboard where leaderboard_id=score_group.leaderboard_id  and name='Survived') where leaderboard_id in (select id from leaderboard);

----------------
-- 2. The following query updates the survived score groups with the number of users that belong to its leaderboard

update score_group set no_of_users=(select count(*) from user_leaderboard where leaderboard_id=score_group.leaderboard_id) where leaderboard_id in (select id from leaderboard) and name='Survived';