| SELECT log_action, count(*) as 'Total'
from logging
WHERE log_type =... |
2 years ago |
| SELECT log_action, count(*) as 'Total 2020'
from logging
WHERE log_type =... |
2 years ago |
| SELECT log_action, substr(log_timestamp,1,6), count(*)
from logging
WHERE... |
2 years ago |
| SELECT log_action, substr(log_timestamp,1,6), count(*)
from logging
WHERE... |
2 years ago |
| SELECT log_action,substr(log_timestamp,1,6), count(*),... |
2 years ago |
| SELECT log_action,substr(log_timestamp;1,6), count(*),... |
2 years ago |
| SELECT log_action,substr(log:timestamp;1,6), count(*),... |
2 years ago |
| SELECT log_action,substr(log:timestamp;1,6), count(*),... |
2 years ago |
| SELECT log_type, log_action,
count(*) from
logging
GROUP by ... |
2 years ago |
| SELECT log_type, log_action,
count(*) from
logging
GROUP by log_action
|
2 years ago |
| SELECT log_action,
count(*) from
logging
GROUP by log_action
|
2 years ago |
| SELECT log_action
count(*) from
logging
GROUP by log_action
|
2 years ago |
| SELECT log_action
count(log_action) from
logging
GROUP by log_action
|
2 years ago |
| SELECT log_type, log_action
count(log_action) from
logging
GROUP by ... |
2 years ago |
| SELECT log_type, log_action
count(log_action) from
logging
GROUP by... |
2 years ago |
| SELECT log_type, log_action
count(log_action) from
logging
GROUP by... |
2 years ago |
| SELECT log_type, log_action
count(log_action) from
logging
GROUP by... |
2 years ago |
| SELECT log_type, log_action
count(*) from
logging
GROUP by log_type,... |
2 years ago |
| SELECT log_type,
count(*) from
logging
GROUP by log_type
|
2 years ago |
| SELECT
count(*) from
logging
GROUP by log_type
|
2 years ago |
| SELECT
count(*), SUBSTR(log_timestamp,1,8)
FROM
logging
WHERE
log_type... |
2 years ago |
| SELECT
count(*),... |
2 years ago |
| SELECT
MAX(count(*)) from
(
SELECT count(t*) from logging
... |
2 years ago |
| SELECT
MAX(count(*)) from
(
SELECT count(t*) from logging
... |
2 years ago |
| SELECT
MAX(
SELECT count(t*) from logging
... |
2 years ago |
| SELECT
SUBSTR(log_timestamp,1,8), max(*)
OVER (PARTITION BY... |
2 years ago |
| SELECT
SELECT
SUBSTR(log_timestamp,1,8), max(*)
OVER (PARTITION BY... |
2 years ago |
| SELECT
SELECT
SUBSTR(log_timestamp,1,8), max(count(*))
OVER... |
2 years ago |
| SELECT
SELECT
SUBSTR(log_timestamp,1,8), max(count(*)
OVER... |
2 years ago |
| SELECT
max(count(*)),... |
2 years ago |
| SELECT
count(*)
FROM
logging, actor
WHERE
log_type=... |
2 years ago |
