with year_month_type as ( select year(CreationDate) as ye...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Monero Meta

Q&A about the site for developers and users of the secure, private and untraceable cryptocurrency Monero

with year_month_type as (
select year(CreationDate) as year,
       month(CreationDate) as month,
       PostTypeId,
       count(*) as num_of_posts
from Posts
group by year(CreationDate),month(CreationDate),PostTypeId
)
select *     
from year_month_type
where PostTypeId=1
and num_of_posts=(
select max(num_of_posts)
from year_month_type
where PostTypeId=1);

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results