SELECT B.date as 'ημερ.', c.total_vaccinated_crit as 'εμβ. ICU', c.total_unvaccinated_crit as 'ανεμβ. ICU',
TRUNCATE((100*(c.total_vaccinated_crit/(B.total_completed/100000)))/((c.total_vaccinated_crit/(B.total_completed/100000))+(c.total_unvaccinated_crit/((10506087 - B.total_completed)/100000))),2) as 'εμβ. %',
TRUNCATE((100*(c.total_unvaccinated_crit/((10506087 - B.total_completed)/100000)))/((c.total_vaccinated_crit/(B.total_completed/100000))+(c.total_unvaccinated_crit/((10506087 - B.total_completed)/100000))),2) as 'ανεμβ. %'
FROM vaccinations B
LEFT JOIN cases c ON c.date = B.date
WHERE B.date >= '2021-08-30'
ORDER BY B.id DESC