• i still have the same error message

    this is what i wrote:

    select top 100 id, personid,name, firstname,

    count (*) mycount

    from [database].

    .

    group by id, personid,name, firstname

    order by mycount;

    and i have the same error saying:

    column is invalid.....