SELECT a.user_uuid, count(*) as cnt, sum(a.active) as active, b.email from FAV01 as a left join USR01 as b on a.user_uuid = b.user_uuid group by user_uuid

User	User_UUID	Aktive	Inaktive