Solving Medium SQL Interview Questions on Analyst Builder

Let's look at how we can solve a medium SQL technical interview question. In this series we work our way through easy, medium, hard, and very hard SQL interview questions that you may see in a technical interview.

____________________________________________

RESOURCES:

Coursera Courses:

Udemy Courses:

*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____________________________________________

BECOME A MEMBER -

Want to support the channel? Consider becoming a member! I do Monthly Livestreams and you get some awesome Emoji's to use in chat and comments!

____________________________________________

Websites:
📱Instagram: @Alex_The_Analyst
____________________________________________

*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*

[fishregulator]

I've been doing data analytics for almost 3 years now and I still learned a few things watching this. Appreciate all you do Alex 🙏

[chiragmaniyath]

I started solving SQL daily because of this series. Thanks a lot and please do continue

[rebekahmenn]

This is great! I'm taking the free Harvard SQL course online, and seeing that these queries are medium-difficulty is encouraging to me... everything made sense and is very straightforward. I really look forward to learning more SQL and getting into this industry!

[raphaelugwoke]

Happy New year Alex, came across your channel December last year and it's been a hell of a ride, keep up the good work mate

[bhavadharini]

Thanks a ton for doing this! The clarity and simplicity is just phenomenal!

[malcorub]

Some of the easy questions start turning into medium questions when you consider the nested functions like with the COSTCO ROTISERIE CHICKEN scenario. SELECT AS DECIMAL), 0) AS Total_Loss FROM sales;
I have an easier time with temp tables, stored procs, creating and inserting into tables than I do nested functions. But still, great learning tool

[wellingtonporto]

Amazing lesson, Alex! Now, I feel confident to delve deeper into SQL knowledge through the AnalystBuilder website, and more importantly, to excel in SQL interview questions.
Thanks a million!

[kre]

Just started learning sql on Udemy this week and I am doing pretty good so far with answering your interview questions

[nicjohnson]

Great content. Your presentation setup and communication skills are superb. One minor suggestion is to be mindful of formatting best practices e.g. each column name on the next line preceeded by its separator comma.
I just unraveled a spaghetti noodle factory of self-taught SQL and the poor formatting added a lot of time. Reading code that is consistently formatted speeds up an analyst's work and following formatting best practices is a sign of your professionalism in an interview.

[Siejec]

Alex never fails to show something fresh and interesting! Props!

[reliablevariable]

As these interview questions get more difficult, it also gets more important to validate the data. In the second example, the data set is small enough to visually confirm that the error is uniform.

If that dataset was 10, 000+ rows long, it will not be practical nor would it be possible to validate the data visually. I’d be asking what types of assumptions do I have with the text and how do I write queries that would check against those assumptions. (E.g., do the names have any trailing or leading space? Is the naming convention for the error always a concatenation of the ID at the beginning or can the error show as First Name and then ID?)

Depending on how big your testing dataset is and who you are speaking to, the thought process can be scaled up or down accordingly.

[SkedlerReports]

Very good video! Good luck to all who read this and are looking for a new job!

[adhamazzam]

Thank you very much, Alex! I just finished watching all your boot camp videos. They are really very helpful for beginners. And thank you for recommending this Analystsbuilder, which is really useful for practicing ❤❤❤really appreciate your help and hard work 😊

[princesrivastava]

Best thing i learn to write down what we need to do in query 🎉🎉🎉

[samscholar]

If things went well, I will share my story and main thanks would be to you and your channel, thank you so much for all of your efforts 🙏

[stingrgaming]

I think these should be classified as Easy not Medium

[ivanko-nebo]

Hi Alex.

There is an issue in "Senior Citizen Discount" moderate SQL question. The task says "If a customer is 55 or above they qualify" - this should be meaning ">=" condition. But it is not accepted as correct by the system. I get "your solution is correct" only if I change to ">", which contradicts the task.

[BeccaNiederkrom]

I've shared your channel with so many Alex, so good! I am an "old" lady now lol but thinking of documenting my journey of learning SQL and seeing where it takes me. =) Maybe inspire some Gen Xers.

[venkatsadineni]

Excellent Info and useful for interview preparation.

[BATMAN-shmm]

Honestly these questions are easy level