CREATE VIEW total_article_scoring_author_view (
 total_scoring,
 user_id
) as 
Select COUNT(*) as total_scoring, sc.user_id 
from scoring as sc 
    where sc.participant_type = 1 and sc.scoring_type = 1 and sc.scoring > 0
GROUP by sc.user_id;