Learn How to Solve SQL Interview Problem for Data Science

In today's video, we are going to be solving SQL problems with medium difficulty. And you are going to watch me make some silly mistake 😬 If you are planning to follow along, I would suggest to pause at each problem and try solving it yourself before seeing my approach and solution in this video. This would be the most optimal way to learn from this video. All the best! Let me know in comments if I should do more of these.

StrataScratch: https://www.stratascratch.com/?via=su...

Questions (Medium difficulty):
1. Top 10 Ranked Songs (Spotify)
2: Top Cool Votes (Yelp)

This video is not sponsored but the link is affiliate, which means I earn a small commission at no cost to you. I would appreciate if you would sign up using this link.

Watch rest of Learn SQL Playlist to keep learning:    • Плейлист  

My Self-Taught Data Science Journey:    • My Data Science Journey with Non-Tech Back...  
How I Would Learn Data Science in 2022:    • How I Would Learn Data Science (If I Could...  
Why is Data Science Job Search Hard?    • Why is it Hard to Find a Job as a Data Sci...  

~~~ CERTIFICATES & COURSES ~~~

DATA SCIENTIST
📊 Data Science Certificate 👉🏼 https://imp.i384100.net/DataScienceCert
🏅 Data Science Bootcamp 👉🏼 https://bit.ly/data-scientist-bootcamp

DATA ANALYTICS
🏅 Google Data Analytics Certificate 👉🏼 https://imp.i384100.net/GoogleDataCert

PYTHON
🐍 Python for Everybody 👉🏼 https://imp.i384100.net/PythonSpec
⚡ Python for Data Science 👉🏼 https://bit.ly/python-data-science-ml
📑 Python for Data Visualization 👉🏼 https://bit.ly/python-data-viz
🏅 Python Pandas 👉🏼 https://bit.ly/python-pandas-data-ana...

SQL
⚡ SQL Basics for Data Science 👉🏼 https://imp.i384100.net/SQLforDS
🏅 SQL Bootcamp 👉🏼 https://bit.ly/sql-bootcamps

MACHINE LEARNING
🏅 Machine Learning Bootcamp 👉🏼 https://bit.ly/machine-learning-atoz
⚙️ Machine Learning Specialization 👉🏼 https://imp.i384100.net/ML

STATISTICS
⚙️ Statistics for Data Analysis 👉🏼 https://bit.ly/statistics-data-science
📑 Intro to Statistics 👉🏼 https://imp.i384100.net/Stats

Excel
🎨 Excel for Data Analysis 👉🏼https://imp.i384100.net/Excel
🎨 Excel Advanced 👉🏼 https://bit.ly/data-scientist-bootcamp

Interviews
🏅 Practice Coding Interviews 👉🏼 https://stratascratch.com/?via=sundas

🌍 ALL COURSES 👉🏼 https://kit.co/SundasKhalid

~~~~~~~~~~~~~~~~~~~~~~~~~~~

MY FAVORITE GEAR
🎥 My YouTube Camera Gear - https://kit.co/SundasKhalid
⌨️ My Desk Setup - https://kit.co/SundasKhalid

MY FAVORITE SOFTWARE
📚 The best summaries of books (Shortform) - https://www.shortform.com/sundas
✍️ Where I take tech courses (Coursera Plus free trial) - https://imp.i384100.net/CourseraPlus

LET'S BE FRIENDS
🌍 My website - https://sundaskhalid.com
📸 Instagram -   / sundaskhalidd  
🐦 Twitter -   / sundaskhalid6  

SUBSCRIBE FOR MORE VIDEOS
https://www.youtube.com/sundaskhalid?...

0:00 Intro
1:11 Question 1
5:10 Question 2
15:46 Outro

BINGE THESE PLAYLISTS NEXT
Starting in Data Science:    • Плейлист  
Learn SQL:    • Плейлист  
The Tech Lounge:    • The Tech Lounge  

ABOUT ME
I'm Sundas. I'm a self-taught data scientist from a non-tech background, currently at a FAANG company. I have been in the industry for over 8 years spread across two big tech companies. On this channel, I share tips for people interested in entering data science with the goal to democratize knowledge and make complicated topics digestible for everyone. All opinions are mine!

PS. Some of the links included are affiliate links and help me keep this channel going. Thanks for the support.

Business inquiries: [email protected]