20 lines
505 B
SQL
20 lines
505 B
SQL
-- noinspection SqlDialectInspectionForFile
|
|
-- noinspection SqlNoDataSourceInspectionForFile
|
|
-- noinspection SqlResolveForFile
|
|
|
|
-- Histogram of template contributions
|
|
select
|
|
date(created_at) as created_date,
|
|
count(*) as template_count
|
|
from w2l_templates
|
|
group by created_date
|
|
|
|
-- Histogram of template contributions (within range)
|
|
select
|
|
date(created_at) as created_date,
|
|
count(*) as template_count
|
|
from w2l_templates
|
|
where created_at > (CURDATE() - INTERVAL 5 DAY)
|
|
group by created_date
|
|
|