CREATE VIEW sum_scoring_quality_rate_view (
 user_id,
 participant_type,
 scoring_type,
 total_scoring
) as
select scoring.user_id AS user_id,scoring.participant_type AS participant_type,scoring.scoring_type AS scoring_type,
            sum(scoring.scoring) AS total_scoring 
            from scoring 
        	where scoring.scoring_type = 3
        	group by scoring.user_id,scoring.participant_type,scoring.scoring_type;
