How can I convert a null value to integer in a select?

  const data = await db.select({
    player_name: tournament_snapshot_detail.player_name,
    ranking: sql<number>`ISNULL(${player.ranking},9999)`
  }).from(tournament_snapshot_detail)
    .leftJoin(player, eq(tournament_snapshot_detail.player_name, player.name))
    .where(and(
      eq(tournament_snapshot_detail.snapshot_id, snapshots[0].value ?? 0),
      eq(tournament_snapshot_detail.amateur, false)))
    .orderBy(player.ranking)

  const data = await db.select({
    player_name: tournament_snapshot_detail.player_name,
    ranking: sql<number>`ISNULL(${player.ranking},9999)`
  }).from(tournament_snapshot_detail)
    .leftJoin(player, eq(tournament_snapshot_detail.player_name, player.name))
    .where(and(
      eq(tournament_snapshot_detail.snapshot_id, snapshots[0].value ?? 0),
      eq(tournament_snapshot_detail.amateur, false)))
    .orderBy(player.ranking)