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 🎉

[@aqib5354]

basically i understood your lecture

[@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

[@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

[@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

[@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.

[@chandanpatra1053]

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

[@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

[@AmbarGharat]

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

[@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!

[@lokeshladdha4520]

WITH stddetail AS
(
SELECT
std_id,
COUNT(course_id) AS no_course_taken,
MAX(COUNT(course_id)) OVER () AS max_courses,
YEAR(date) AS year
FROM
students
WHERE
YEAR(date) = '2019'
GROUP BY
std_id,
YEAR(date)
)
SELECT
std_id
FROM
stddetail
WHERE
no_course_taken = max_courses;

[@Sagar_Rao_]

can u share the questions pdf

[@zero_analyst]

Its updated in my github click the link from bio

[@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 🙏🙏