0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors

with t as (
select month(creationdate) as month,
year(creationdate) as year,
count (*) as num
from users as u
group by year(creationdate), month(creationdate)
)
select * from t where num = (select max(num) from t)

fork query

created dec 9 19 anonymous