How to Solve SQL Interview Problems | Learn SQL Part 2/n

Hi friends, today we are solving 3 medium SQL Leetcode problems. 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.

The problem we are solving today:
Problem 1: https://leetcode.com/problems/second-highest-salary/
Problem 2: https://leetcode.com/problems/rank-scores/
Problem 3: https://leetcode.com/problems/nth-highest-salary/

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
⚡ IBM Data Analytics Certificate ?? https://imp.i384100.net/ibm-data-analyst

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

? 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
? Read Books FAST on Shortform ?? https://www.shortform.com/sundas
✍️ Coursera Plus 7 day 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 Problem 1
8:31 Problem 2
13:56 Problem 3
18:43 What we learned today?

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]