le jour du mois où le plus grand nombre de question ont été posées en octobre

0

Please login or register to vote for this query.

(click on this box to dismiss)

The Workplace Meta

Q&A about the site for members of the workforce navigating the professional setting

select day(p.creationdate), count(pt.id)
from posts p
  join posttypes pt on p.posttypeid=pt.id
where pt.name='Question' AND
      year(p.creationdate)='2018' AND
      month(p.creationdate)='10'
group by day(p.creationdate)

Enter Parameters

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