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=sundas

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: https://youtube.com/playlist?list=PLNvMRDyXHRne8qEj3Uipdt4eqkmN1z7bG

My Self-Taught Data Science Journey: https://youtu.be/34r9OwjysDM
How I Would Learn Data Science in 2022: https://youtu.be/65yXoFc5stI
Why is Data Science Job Search Hard? https://youtu.be/fc6ZQX46Kz8

~~~ 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-analysis

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 - https://instagram.com/sundaskhalidd
? Twitter - https://twitter.com/sundaskhalid6

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

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

BINGE THESE PLAYLISTS NEXT
Starting in Data Science: https://youtube.com/playlist?list=PLNvMRDyXHRnfRw-wJa4BSUdZjtnBEXkGH
Learn SQL: https://www.youtube.com/playlist?list=PLNvMRDyXHRne8qEj3Uipdt4eqkmN1z7bG
The Tech Lounge: https://www.youtube.com/playlist?list=PLNvMRDyXHRneiXWLSPJX2ZhMp09bpSJkV

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]