dev/2020/2020-016(OK)/2020-016-ljh-001.sql

USE DCP;
--创建关注视图表
CREATE VIEW base_portal_model_follow_info_groupby_userId
AS
select user_id,count(1) as nums
from base_portal_model_follow_info
GROUP BY user_id;

CREATE VIEW base_portal_model_follow_info_groupby_model
AS
select model_type,model_entity_id,count(1) as nums
from base_portal_model_follow_info
GROUP BY model_type,model_entity_id;