with t as( select year(CreationDate) as y, month(Creation...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Christianity

Q&A for committed Christians, experts in Christianity and those interested in learning more

with t as(
select year(CreationDate) as y, month(CreationDate) as m, count(*) as c
from Users
group by year(CreationDate), month(CreationDate)
)

select y, m
from t
where c = (select max(c) from t)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results