CREATE DATABASE Bar
USE Bar

select  *,PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY daily_vaccinations ASC)
		OVER (PARTITION BY country) AS MedianCont
from    country_vaccination_stats
WHERE daily_vaccinations IS NOT NULL
ORDER BY country ASC

select *,
		ISNULL(daily_vaccinations,0) as daily_vaccinations
from country_vaccination_stats