export async function getYearsThatHaveVotes({ division }: { division: string }) {
const yearsWithVotes = await db
.select({
year: sql<number>`DISTINCT ${weeklyFinalRankings.year}`,
})
.from(weeklyFinalRankings)
.where(sql`${weeklyFinalRankings.division} = ${division}`)
.orderBy(sql`${weeklyFinalRankings.year} DESC`)
return yearsWithVotes
}
export async function getYearsThatHaveVotes({ division }: { division: string }) {
const yearsWithVotes = await db
.select({
year: sql<number>`DISTINCT ${weeklyFinalRankings.year}`,
})
.from(weeklyFinalRankings)
.where(sql`${weeklyFinalRankings.division} = ${division}`)
.orderBy(sql`${weeklyFinalRankings.year} DESC`)
return yearsWithVotes
}