with t(userid, product, log_date ) as (
select 1,    'aaa',     '02-02-2020' from dual union all
select 2,    'aaa',     '05-01-2020' from dual union all
select 1,    'aaa',     '03-02-2020' from dual union all
select 2,    'aaa',     '06-01-2020' from dual union all
select 3,    'ccc',     '09-08-2020' from dual
)
select product, count(*) total_entries, count(distinct userid) total_users
from t
group by product;

PRODUCT TOTAL_ENTRIES TOTAL_USERS
------- ------------- -----------
ccc                 1           1
aaa                 4           2

请尝试以下操作：

SELECT 
product,
count(*) OVER (partition by product) total_entries,
count(*) over(partition by product,user ) total_users
from table;