Solving Easy SQL Interview Questions on Analyst Builder

Questions Page on Analyst Builder: www.analystbuilder.com/questions
Car Failure Question: www.analystbuilder.com/questi...
Apply Discount Question: www.analystbuilder.com/questi...
Let's look at how we can solve an Easy 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:
💻Analyst Builder - www.analystbuilder.com/
📖Take my Full MySQL Course Here: bit.ly/3tqOipr
📖Take my Full Python Course Here: bit.ly/48O581R
📖Practice Technical Interview Questions: bit.ly/46pDqqL
Coursera Courses:
Google Data Analyst Certification: coursera.pxf.io/5bBd62
Data Analysis with Python - coursera.pxf.io/BXY3Wy
IBM Data Analysis Specialization - coursera.pxf.io/AoYOdR
Tableau Data Visualization - coursera.pxf.io/MXYqaN
Udemy Courses:
Python for Data Science - bit.ly/3Z4A5K6
Statistics for Data Science - bit.ly/37jqDbq
SQL for Data Analysts (SSMS) - bit.ly/3fkqEij
Tableau A-Z - bit.ly/385lYvN
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!
/ @alextheanalyst
____________________________________________
Websites:
💻Website: AlexTheAnalyst.com
💾GitHub: github.com/AlexTheAnalyst
📱Instagram: @Alex_The_Analyst
____________________________________________
0:00 Intro
2:33 First Question
6:58 Second Question
11:44 Outro
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

[@jeffrey2513]

This is easily the best data analyst channel on KZbin, no one else is putting out content like this. Really appreciate it

[@magdalenekimani8549]

I love the fact that you remind us to talk it out loud and walk the interviewer through what we are doing. That's what sets us apart from the rest.

[@absoon9971]

Just in time for my job interview. I don't have any certification, didn't even finish college. I just watched all of your Data Analyst Bootcamp and I can't even thank you enough. I'm looking forward to get your Analyst Builder. And I got multiple interviews all thanks to you ALEX!!!

[@wellingtonporto2682]

Thank you so much, Alex! It was a great video SQL lesson. I appreciate it, and looking forward to the next SQL interview questions.

[@BeanWorks91]

I am such a huge fan of your comments in the editor. Plus the concept of “explaining your thought process to the technical interviewer”. Great way by build the confidence as well if you actually know the theory behind what you are doing 🎉

[@reliablevariable1615]

Great video! One thing I would add is that not all interviewees will get a chance to live code as part of their interview process; some will only send this question to you as a take-home. The expectation, then, is to send back the query (unless the questions explicitly ask you to elaborate more on your thought process). In this basic query, though, the comments should suffice in succinctly conveying the thought process. I was lucky enough to have a senior data analyst go back-and-forth with me to learn SQL. To be fair, it was SQL Developer, which is a less "conventional" SQL language...

[@imadethiscuziwsbored]

I finished your free youtube sql series and tried these questions by myself before watching the vids and passed! Kinda feels like my first real solo accomplishment with sql ^_^ thank you for being a great teacher and im excited to keep learning more

[@kehindekehinde9719]

Yes, I enjoyed the video Thanks so much for sharing Alex.

[@somaansa939]

Awesome 👍 Thanks a million Alex!

[@shohaibameer1043]

Hi Alex plz upload the power bi ,and tableau interview questions also

[@adeagboadelekanbenjamin9497]

Thanks🎉. I have no regret of buying Analyst Builder Course Bundle. Cheers !!!

[@Zenitsu-mq7fq]

Best site Ever, Ty Alex!

[@calebaiyegboka3247]

That was a wonderful video, I'll practice on it to prepare for my interviews 😊

[@pavaniDusari]

Great one expecting more such videos for interview preparation ❤♥

[@mahmoudfadaly8074]

really words can't describe how much all of us are grateful for u for making everything east for us , thanks alot , hope you r doing great

[@ChingeToloza]

We are grateful indeed 🤲💯

[@Charlesanalyst]

Wonderful!!! You are the best. ❤I heart you from Nigeria

[@dominiquepenn9477]

Thank you !

[@makemymarket1772]

Awesome!

[@River049]

Nice sh!t Alex! :)

[@hanumanths3692]

00:01 Solving easy SQL technical interview questions is important for data analyst positions. 01:18 Practicing SQL interview questions on Analyst Builder. 02:44 Write a query to identify cars that passed inspection and list owner name and vehicle name ordered by owner name alphabetically. 04:29 Filter cars without critical or with three or less minor issues 06:09 Ordering data in SQL using 'order by' clause 07:41 Identifying new customers without duplicates 09:16 Filtering based on age and total purchase amount 10:53 Articulate your thought process and earn points by solving easy SQL interview questions on Analyst Builder.

[@user-hk5dq5fc4c]

Hey ALex hope you are doing good. I have been learning allot from your videos. I just have one request. Can you make a video on SQL explaining how to connect with cloud servers and company servers?

[@veronicambah7108]

Thanks Alex_ Analyst

[@sprouse9]

Over 65 usually includes 65. I would clarify that with HR

[@tolaakinola8930]

Hello Alex, thanks for all you do. It is inspiring! I would like to know regarding the car inspection question, should the minor issues not be written as minor issues >3 since the question said a car with minor issues more than 3 will fail.

[@magdalenekimani8549]

This is the catching point *Write a query to identify all of the cars * so your query will be >=3 The interviewer will always twist the question one way or another. This is where your attention to details comes in 🤣

[@bradpalmer1751]

I totally bombed on an interview with Amazon for a BI Engineer about a month ago. I have been out of work for over a year and forgot basic syntax. I also was not prepared for how they just paste a bunch of text into the chat window and say "Pretend these are records in a database and write a query that..." I thought I would get access to a database, get my queries together, and paste them into the chat window.

[@malcorub]

So you had to free hand SQL into a chat window? Interesting to see how various companies handle the technical interview.

[@bradpalmer1751]

@@malcorub Exactly. It was pretty bizarre. I launched VS Code so my query would be formatted nicely for readability and Chime told the interviewer that its window did not have focus. He told me to maximize Chime and not click out of it for the duration of the interview. He was a nice guy, but my anxiety was through the roof and I just kind of froze up at that point.

[@ChingeToloza]

Please we need more exercise on this , thank you very much Mr Alex_Analyst And please can you differentiate ( or explain with a short )between SQL and MySQL and other versions because I don't really know their differences and similarities, and again do we have to pay to access the website before going through these examples ? Thank you in advance 🤲

[@AlexTheAnalyst]

There are different "flavors" or types of SQL. I have a few videos on this :) and there are free questions on the platform as well as premium questions.

[@ChingeToloza]

@@AlexTheAnalyst okay thanks I just joined the discord team now , so where do I get these videos so I can be able to differentiate them

[@sk45293]

visually checking for dupilcate customer_id works in this case but would be difficult in a long table. This could be sped up by: SELECT COUNT(customer_id) AS total_purchases, COUNT(DISTINCT customer_id) AS unique_customers FROM customers;

[@Dinma.k]

Hi Alex, looking at becoming a data analyst this year and I have been following your boot camps. I would like to ask a question; Most of the softwares used in your videos are done on a PC my question is what is your advise for people with MacBook, is it possible to learn on them (SQL, Tableau etc)?

[@AlexTheAnalyst]

You can still use a MacBook. I bought one myself and there are lots of great alternatives.

[@Dinma.k]

@@AlexTheAnalyst Yh but I find it had to access the SQL software

[@darijozivkovic7931]

Alex I'm having a problem with postgres first on Mint, now on Windows: User pg_restore: error: input file does not appear to be a valid archive . I don't get it how to solve it?

[@user-bv2qd5wt1q]

Some customers are over 65 AND purchased more than 200 dollars, so I think distinct-count would be a better way to approach. Anyone agrees?

[@newenglandnomad9405]

My question is, i understand the queries you wrote, what I don't understand are the real world use. I also understand that you're showing really simple csv files, and the real purpose of sql is that you might have a million lines of data. For finance, would your boss maybe ask you to find the customers that earned over 5% in their portfolio in 2023 or how many people over 67 starting withdrawing from their Roth IRA? I get the simplicity you're trying to show, I'm just curious about real world use.

[@Mister_Garibaldi]

These are very simple examples. Most queries on the job aren't that simple. I have some queries that are hundreds of lines of SQL (and bigger actually)....things like decile analysis, or customer life cycle stage for example. The exercises here are examples of a few basic concepts, building blocks, that you combine with other methods. Also, he's demonstrating how to think through an exercise, note how he writes comments in the code first (pseudo code) to establish the goals and logic, then fills in the SQL code after. Also note how he's doing a broad SELECT * to explore the data beforehand.

[@newenglandnomad9405]

@@Mister_Garibaldi That was my guess. Thanks very much for sharing.

[@aidanthompson5053]

3:45

[@aimanmalik5289]

Is your course permanent sir?

[@vladton84]

Always on 0.75 speed😊

[@Tantepa]

Anyone else have problem signing back in?

[@1poised]

Hi Alex I do not know if you are more active here or tik tok but I sent a message on tik tok! If not please let me know I’ll send it here? Thank you