Q:

How to check condition for every month between two date

I am working on the stack exchange database for a project.(https://data.stackexchange.com/stackoverflow/query/new)
I would like to know TOP 10 users who have posting every month between there are registered in database.
I have tried this but I am lost : 
SELECT TOP 10 
   Propriétaire 
FROM 
   (SELECT 
      count(Mois) AS nbMoisPosté, 
      datediff(month, création, getdate()) AS nbMoisTotal, 
      Propriétaire 
    FROM
       (SELECT 
          count(Posts.Id) AS nbPosts,
          month(Posts.creationDate) AS Mois,
          year(Posts.creationDate) AS Année
          Posts.ownerUserId AS Propriétaire,
          Users.creationDate AS création
       FROM 
          Posts, Users
       WHERE 
          Users.Id = Posts.ownerUserId
       GROUP BY 
          Posts.ownerUserId, 
          Mois, 
          Année, 
          création) compte
   GROUP BY 
      datediff(month, création, getdate()), 
      Propriétaire) nbMois
WHERE nbMoisPosté = nbMoisTotal

It doesn't work (syntax error) but I don't understand my mistake.
Thanks.

A:

Try correcting these issues.
Please make sure you post your error messages
SELECT TOP 10 
    Propriétaire 
FROM 

    (
    SELECT 
        count(Mois) AS nbMoisPosté, 
        datediff(month, création, getdate()) AS nbMoisTotal, 
        Propriétaire 
    FROM
        (
        SELECT 
            count(Posts.Id) AS nbPosts, 
            month(Posts.creationDate) AS Mois,
            year(Posts.creationDate) AS Année   --MISSING COMMA
            Posts.ownerUserId AS Propriétaire,
            Users.creationDate AS création
        FROM 
            Posts, 
            Users
        WHERE 
            Users.Id = Posts.ownerUserId
        GROUP BY 
            Posts.ownerUserId, 
            Mois, --GROUP BY THE FUNCTION month(Posts.creationDate)
            Année, --GROUP BY THE FUNCTION year(Posts.creationDate)
            création

            ) compte
    GROUP BY 
        datediff(month, création, getdate()), 
        Propriétaire
        ) nbMois
WHERE 
    nbMoisPosté = nbMoisTotal

