SELECT COUNT(admin_id), admin_id, a.admname, date_part('month', f.created_at)
FROM new_1report f
JOIN admin a ON f.admin_id = a.id
group by admin_id, a.admname, date_part('month', f.created_at)with min as
(
select
cast(extract(epoch from time) as integer) as time
from records
where time >= '2016-01-01 06:36:12'
order by time asc
limit 1
), max as (
select
cast(extract(epoch from time) as integer) as time
from records
where time <= '2016-02-01 06:36:12'
order by time desc
limit 1
)
select (max.time - min.time) t1
from min, max