CREATE VIEW scoring_quality_rate_view (
 user_id,
 participant_type,
 rate
) as
select scoring_amount.user_id AS user_id,
scoring_amount.participant_type AS participant_type,
(scoring_amount.total_scoring / scoring_count.count_scoring) AS rate
from ((
    (
        select sc.user_id ,sc.participant_type ,sc.scoring_type, sc.total_scoring 
            from sum_scoring_quality_rate_view sc 
        	
    )
    )
     scoring_amount join (
                        select sc.user_id, sc.participant_type, sc.scoring_type, sc.count_scoring 
                        from count_scoring_quality_rate_view sc
                    )
      scoring_count on(
                            (
                                (scoring_amount.user_id = scoring_count.user_id) 
                                and (scoring_amount.participant_type = scoring_count.participant_type) 
                                and (scoring_amount.scoring_type = scoring_count.scoring_type)
                            )
                        )
    )
    where scoring_amount.scoring_type = 3