I've been using below query to get the desired value and it gives me the correct output, but is there any way to simplify this query?
SELECT (
(SELECT count(DISTINCT user_id)
FROM table1
WHERE date between '2022-01-01' and '2022-01-20'
AND page_urlpath like '