20 lines
460 B
SQL
20 lines
460 B
SQL
-- noinspection SqlDialectInspectionForFile
|
|
-- noinspection SqlNoDataSourceInspectionForFile
|
|
-- noinspection SqlResolveForFile
|
|
|
|
-- All users
|
|
select count(*) from users;
|
|
|
|
-- Users registered in the last year
|
|
select count(*)
|
|
from users
|
|
where created_at > ( CURDATE() - INTERVAL 365 DAY )
|
|
|
|
-- Histogram of user signups
|
|
select
|
|
date(created_at) as created_date,
|
|
count(*) as registered
|
|
from users
|
|
where date(created_at) >= "2023-01-01"
|
|
group by created_date
|