SELECT
DATE(rc_timestamp) AS day,
COUNT(DISTINCT rc_actor) AS dau
FROM... |
4 years ago |
SELECT
WEEK(rev_timestamp) AS week,
COUNT(DISTINCT rev_actor) AS wau
FROM... |
4 years ago |
SELECT
WEEK(rev_timestamp) AS week,
COUNT(DISTINCT rev_actor) AS wau
FROM... |
4 years ago |
SELECT
WEEK(rev_timestamp) AS week,
COUNT(DISTINCT rev_actor) AS wau
FROM... |
4 years ago |
SELECT
EXTRACT(YEAR_MONTH FROM rev_timestamp) AS month,
COUNT(DISTINCT... |
4 years ago |
SELECT
EXTRACT(YEAR_MONTH FROM rev_timestamp) AS month,
COUNT(DISTINCT... |
4 years ago |
SELECT
EXTRACT(YEAR_MONTH FROM rev_timestamp) AS month,
COUNT(DISTINCT... |
4 years ago |
SELECT
EXTRACT(YEAR_MONTH FROM rec_timestamp) AS month,
COUNT(DISTINCT... |
4 years ago |
SELECT
EXTRACT(YEAR_MONTH FROM rc_timestamp) AS month,
COUNT(DISTINCT... |
4 years ago |
SELECT
EXTRACT(YEAR_MONTH FROM rev_timestamp) AS month,
COUNT(DISTINCT... |
4 years ago |
SELECT
EXTRACT(YEAR_MONTH FROM rev_timestamp) AS month,
COUNT(DISTINCT... |
4 years ago |
SELECT
EXTRACT(YEAR_MONTH FROM rev_timestamp) AS month,
COUNT(DISTINCT... |
4 years ago |
SELECT
EXTRACT(YEAR_MONTH FROM rev_timestamp) AS month,
COUNT(DISTINCT... |
4 years ago |
SELECT
EXTRACT(YEAR_MONTH FROM rev_timestamp) AS month,
COUNT(DISTINCT... |
4 years ago |
SELECT
EXTRACT(YEAR_MONTH FROM rev_timestamp) AS month,
COUNT(DISTINCT... |
4 years ago |
SELECT
EXTRACT(YEAR_MONTH FROM rev_timestamp) AS month,
COUNT(DISTINCT... |
4 years ago |
SELECT
EXTRACT(YEAR_MONTH FROM rev_timestamp) AS month,
COUNT(DISTINCT... |
4 years ago |
SELECT
EXTRACT(YEAR_MONTH FROM rev_timestamp) AS month,
COUNT(DISTINCT... |
4 years ago |
SELECT
EXTRACT(YEAR_MONTH FROM rc_timestamp) AS month,
COUNT(DISTINCT... |
4 years ago |
SELECT
EXTRACT (YEAR_MONTH FROM rc_timestamp) AS month,
COUNT(DISTINCT... |
4 years ago |
SELECT
(EXTRACT YEAR FROM rc_timestamp) AS month,
COUNT(DISTINCT rc_actor)... |
4 years ago |
SELECT
(EXTRACT YEAR_MONTH FROM rc_timestamp) AS month,
COUNT(DISTINCT... |
4 years ago |
SELECT
MONTH(rc_timestamp) AS month,
COUNT(DISTINCT rc_actor) AS mau
FROM... |
4 years ago |
SELECT
MONTH(rc_timestamp) AS month,
COUNT(DISTINCT rc_actor) AS mau
)
FROM... |
4 years ago |
SELECT
(EXTRACT(YEAR_MONTH FROM rc_timestamp) AS month,
COUNT(DISTINCT... |
4 years ago |
SELECT
(EXTRACT(YEAR_MONTH, rc_timestamp) AS month,
COUNT(DISTINCT... |
4 years ago |
SELECT
(EXTRACT('month', rc_timestamp) AS month,
COUNT(DISTINCT rc_actor)... |
4 years ago |
SELECT
(EXTRACT('month', rc_timestamp) AS month,
COUNT(DISTINCT rc_actor)... |
4 years ago |
SELECT
EXTRACT('month', rc_timestamp) AS month,
COUNT(DISTINCT rc_actor) AS... |
4 years ago |
@@version |
4 years ago |
version |
4 years ago |
show table status; |
4 years ago |
SELECT
TRUNC(rc_timestamp, 'MONTH') AS month,
COUNT(DISTINCT rc_actor) AS... |
4 years ago |
SELECT
TRUNC('month', rc_timestamp) AS month,
COUNT(DISTINCT rc_actor) AS... |
4 years ago |
SELECT
DATE_TRUNC('month', rc_timestamp) AS month,
COUNT(DISTINCT rc_actor)... |
4 years ago |
SELECT
DATE_TRUNC('month', rc_timestamp) AS month,
COUNT(DISTINCT rc_actor)... |
4 years ago |
SELECT
DATE_TRUNC('month', rc_timestamp) AS month,
COUNT(DISTINCT rc_actor)... |
4 years ago |
SELECT
DATE_TRUNC('month', rc_timestamp) AS month,
COUNT(DISTINCT rc_actor)... |
4 years ago |
SELECT
DATE_TRUNC('month', rc_timestamp>date_format) AS... |
4 years ago |