CREATE VIEW count_scoring_puntuality_rate_view (
 user_id,
 participant_type,
 scoring_type,
 count_scoring
) as
select scoring.user_id AS user_id,scoring.participant_type AS participant_type,
                        scoring.scoring_type AS scoring_type,count(scoring.scoring) AS count_scoring 
                        from scoring where (scoring.scoring > 0) 
         				and scoring.scoring_type = 1 group by scoring.user_id,scoring.participant_type,scoring.scoring_type