Day 1: Solving Amazon SQL Interview Questions

No video

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

Рет қаралды 3,930

Күн бұрын

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"

Пікірлер: 31

@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 28 күн бұрын

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 4 күн бұрын

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;