Struggling with a GROUP BY count

const data = await db
  .select({
    ...getTableColumns(songHistory),
    count: sql<number>`cast(count(${songHistory.id}) as int)`,
  })
  .from(songHistory)
  .where(and(eq(songHistory.user_id, user!).if(typeof user === 'number'), gte(songHistory.played_at, from!).if(!!from)))
  .groupBy(songHistory.song_title)
  .orderBy(desc(songHistory.played_at));

const data = await db
  .select({
    ...getTableColumns(songHistory),
    count: sql<number>`cast(count(${songHistory.id}) as int)`,
  })
  .from(songHistory)
  .where(and(eq(songHistory.user_id, user!).if(typeof user === 'number'), gte(songHistory.played_at, from!).if(!!from)))
  .groupBy(songHistory.song_title)
  .orderBy(desc(songHistory.played_at));

column "song_history.id" must appear in the GROUP BY clause or be used in an aggregate function

column "song_history.id" must appear in the GROUP BY clause or be used in an aggregate function