Recieve This error when putting in the query below: "Msg 245, Level 16, State 1, Line 63 Conversion failed when converting the nvarchar value 'z' to data type int." Select SUM(new_cases) as total_cases, SUM(cast(new_deaths as int)) as total_deaths, SUM(cast(new_deaths as int))/SUM(New_Cases)*100 as...

When I click on the download option for the Nashville Housing data, the page buffers for a while and then shows the below error. https://drive.google.com/file/d/1KvuNOq-lOhx1QiTzajLN6isZjJdPcDKz/view?usp=sharing . So Alex can you please re upload the file or tell us any walkaround for this problem....

Hi at 1:09:14, when creating a table, I have an issue ---- Temp Table --Drop Table if exists #PercentPopulationVaccinated --create table #PercentPopulationVaccinated --( --continent nvarchar(255), --location nvarchar(255), --date datetime, --population numeric, --new_vaccinations numeric, --RollingP...

Hey, Alex. I would appreciate it if you could help me, I can't figure out how to fix this error: Conversion failed when converting the nvarchar value '2859.0' to data type int. thank you Select dea.continent, dea.location, dea.date, dea.population, vac.new_vaccinations , SUM(CONVERT(int,vac.new_vac...

Could you please upload the dataset which you are using for Movie Portfolio Project.ipynb

Hi Alex, I wanted to say thank you first for your amazing YouTube videos and I definitely think you've made great guidance for us on the journey of Data Analysis :) I really appreciate you! I had this issue when creating the CTE: "Arithmetic overflow error converting expression to data type int" .....

Hello Alex! Great content on YouTube, Please I am experiencing some issues with importing the table into SQL. I was able to do the covid deaths table, but the covid vaccination table keeps displaying an error message, Kindly find attached a screenshot of the error page. Please how do I rectify this...