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

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

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

[@Maheshsai-it4uu]

Thank you sir 🎉

[@aqib5354]

basically i understood your lecture

[@sabShrav]

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

[@Shekar_TechPhoenix]

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

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

[@Shekar_TechPhoenix]

Thank you ​@@zero_analyst

[@chandanpatra1053]

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

[@Sagar_Rao_]

can u share the questions pdf

[@zero_analyst]

Its updated in my github click the link from bio

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

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

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

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

[@haroldkumarnaik9971]

Please share all question pdf of this pdf

[@zero_analyst]

Please check the github rep!

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

[@LokeshGola-ti8ru]

Bhai 1-2 Hindi m Bno do 🙏🙏

[@HARSHRAJ-wz2rp]

with cte as( select * FROM student_batch where EnrollmentYear=2019 ) select StudentID FROM cte GROUP BY StudentID HAVING COUNT(DISTINCT CourseID)= (select COUNT(DISTINCT CourseID) FROM student_batch where EnrollmentYear=2019);