SELECT
   v.country, v.DATE,
   COALESCE(v.daily_vaccinations, (COALESCE((MEDIAN(v.daily_vaccinations) OVER (PARTITION BY v.country)), 0.0))) AS daily_vaccinations,
   v.vaccines,
FROM VACCINATION v ;