How to Join/subquery when using orderBy and groupBy

      const data = await ctx.db
        .select({
          propositionId: propositionsVotes.propositionId,
          twitchSubscriptionsCount: sql<number>`cast(count(nullif(${propositionsVotes.twitchSubscribed},false)) as int)`,
          youtubeSubscriptionsCount: sql<number>`cast(count(nullif(${propositionsVotes.youtubeSubscribed},false)) as int)`,
          normalVotesCount: sql<number>`cast(count(${propositionsVotes.profileId}) as int)`,
          proposition: WRITE SOMETHING THAT WILL GIVE ME PROPOSITION DATA IN HERE
        })
        .from(propositionsVotes)
        .groupBy(propositionsVotes.propositionId)
        .orderBy(
          sql<number>`cast(count(${propositionsVotes.twitchSubscribed}) as int)`,
        );

      const data = await ctx.db
        .select({
          propositionId: propositionsVotes.propositionId,
          twitchSubscriptionsCount: sql<number>`cast(count(nullif(${propositionsVotes.twitchSubscribed},false)) as int)`,
          youtubeSubscriptionsCount: sql<number>`cast(count(nullif(${propositionsVotes.youtubeSubscribed},false)) as int)`,
          normalVotesCount: sql<number>`cast(count(${propositionsVotes.profileId}) as int)`,
          proposition: WRITE SOMETHING THAT WILL GIVE ME PROPOSITION DATA IN HERE
        })
        .from(propositionsVotes)
        .groupBy(propositionsVotes.propositionId)
        .orderBy(
          sql<number>`cast(count(${propositionsVotes.twitchSubscribed}) as int)`,
        );