Day 1: Solving Amazon SQL Interview Questions | 100 Days Challenge

Welcome to Day 1 of my 100 Days Challenge! Today, we're diving into Amazon SQL interview questions to help you ace your next tech interview. Join me as I walk through each problem step-by-step, providing detailed explanations and practical tips. Don't forget to like, subscribe, and hit the bell icon to stay updated with daily challenges!
Join the 100 Days Challenge Community:
Discord: / discord
GitHub: github.com/naj...
Relevant Playlists:
SQL Interview Prep: • SQL Challenge - Data A...
#AmazonInterview #SQLInterviewQuestions #100DaysChallenge #DataScience #SQLTutorial #TechInterviews #DataAnalysis #LearnSQL #InterviewPrep #CodingChallenge #TechCareer #SQLPractice #AmazonTech #DataEngineering #PythonInterview #ExcelTips"

[@vinothkumars7421]

Thanks again. Way to go. Looking for the next 99 Days

[@bankimdas9517]

Thanks for bringing this new sql challenge playlist.

[@shefalikathapa13]

I usually don't comment on videos but your series is really good! Keep up the great work! Really grateful to you. If you could come up with Python Data Analyst Interview questions, it will be great. Cheers! 🎉

[@zero_analyst]

Thanks, will do!

[@Maheshsai-it4uu]

Thank you sir 🎉

[@moureanyuvi]

with cte as(
select count(distinct(CourseId)) as department from student_batch where EnrollmentYear = '2019'
),
cte1 as (select StudentID,count(distinct(CourseId)) as total_department from student_batch
where EnrollmentYear = '2019'
group by StudentID )
select cte1.StudentID from cte join cte1
where department = total_department

[@aqib5354]

basically i understood your lecture

[@user-wi7mt5st2s]

Sir am getting error in the second question while executing ,"Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INT)' at line 3
" please help me on this . thanks

[@rajashekarenagandula3913]

Please provide us with the table DDL script, and insert values in description so it will ease us to practice

[@zero_analyst]

Check the github link!
Its uploaded

[@chandanpatra1053]

please write the question in the ide for the solution you are explaining.

[@omrahulpandey]

Hi Sir, can you share the pdf or atleast the questions also, as if we want to practice later on, we can do it our self. Your github repo with the .sql file has only answer but not the question.

[@zero_analyst]

Check the github link question along with dataset is uploaded you can copy paste and practice

[@rajashekarenagandula3913]

Thank you ​@@zero_analyst

[@shekarsamurai]

MySQL query for full join:
SELECT t1.c1, t2.c2
FROM t1
LEFT JOIN t2 ON t1.c1 = CAST(t2.c2 AS SIGNED)
UNION
SELECT t1.c1, t2.c2
FROM t1
RIGHT JOIN t2 ON t1.c1 = CAST(t2.c2 AS SIGNED);
-- In MySQL, SIGNED is used to cast a string to an integer.

[@AmbarGharat]

Full Outer Join : All numbers from left and rest NULL as its full outer join.

[@abhishekpatil7336]

Bro but what happened if the interview asked to don't pass year and count explicitly.

[@zero_analyst]

Will make a video on this!

[@anushas1910]

Hi, I can see only codes for the questions, please share the file for questions in repo.

[@zero_analyst]

Its uploaded in the github please check day1 pdf

[@Sagar_Rao_]

can u share the questions pdf

[@zero_analyst]

Its updated in my github click the link from bio

[@krishnasai5806]

Where this coding questions? platform

[@zero_analyst]

Download PgAdmin 4 you can practice by yourself!
You can get the questions and dataset from my github!

[@haroldkumarnaik9971]

Please share all question pdf of this pdf

[@zero_analyst]

Please check the github rep!

[@LokeshGola-ti8ru]

Bhai 1-2 Hindi m Bno do 🙏🙏