How can I run a SQL query to get the unique visitors in a certain time?

Hi I just want to check how can I query this result on SQL?


I checked on this link for the SQL query to select all visits and actions (during a certain time period)

And I tried COUNT(Distinct matomo_log_visit.idvisitor) but it has a different value from the matomo dashboard.

Nevermind. I got this already. It is due to the timezone difference