SELECT user_id,
SUM(CASE WHEN calls_day.day BETWEEN  '2022-08-01' AND '2022-08-05' THEN 1 END) AS week1
from calls_day
group by user_id