每个用户查询每个类型的明星的最高次数
use java9;
– 每个用户查询明星的次数
select count(),user_id from user_star group by user_id;
– 每个用户的每种明星类型的查询次数
select count(),u.user_id,s.type from user_star u left join star s on(u.star_id=s.id) group by user_id,s.type;
select count(*),u.user_id,s.type,s.id from user_star u left join star s on(u.star_id=s.id) group by user_id,s.type,s.id;
select count(*),u.user_id,s.type,s.id from user_star u left join star s on(u.star_id=s.id) group by user_id,s.type,s.id;