22 lines
434 B
SQL
22 lines
434 B
SQL
SELECT
|
|
CONCAT(
|
|
EXTRACT(YEAR FROM w.created_at),
|
|
'-',
|
|
EXTRACT(WEEK FROM w.created_at)
|
|
) as week,
|
|
COUNT(DISTINCT s.distinct_id)
|
|
FROM
|
|
website_event AS w
|
|
JOIN
|
|
session as s ON s.session_id = w.session_id
|
|
WHERE
|
|
w.website_id = '16e7d807-4db5-45fd-92a9-27393445a153'
|
|
AND w.event_type = 1
|
|
AND s.distinct_id IS NOT NULL
|
|
AND substring(s.distinct_id SIMILAR '%#"@%#"' ESCAPE '#') <> '@oceanbox.io'
|
|
GROUP BY
|
|
week
|
|
ORDER BY
|
|
week
|
|
;
|