Practice SQL Interview Questions on LeetCode | Solve SQL Interview Questions (Practice SQL Queries)

Practice SQL Interview Questions on LeetCode | Solve SQL Interview Questions (Practice SQL Queries)
In this video, we shall see how to solve SQL questions on LeetCode. LeetCode is a good platform for practicing SQL Queries. The SQL Questions on LeetCode are framed pretty similar to how they are asked on SQL Interviews hence solving SQL questions on LeetCode can give you a good hands on experience on solving real world SQL questions.

Timestamp:
00:00 Intro
02:00 Introduction to LeetCode and How to use it
04:02 Solving LeetCode SQL Question no 197. Rising Temperature
16:00 Solving LeetCode SQL Question no 262. Trips and Users
38:01 Solving LeetCode SQL Question no 1179. Reformat Department Table

LeetCode is a platform where you can find programming question which can be solved using several different programming languages such as Python, Java, Java Script, C, C++, PHP, Ruby and many more. LeetCode also has questions related to SQL which can be solved using either Oracle, MySQL or Microsoft SQL Server databases.

If you are a beginner in SQL or if you are preparing for SQL Interview thenI highly recommend solving SQL queries on LeetCode. Now most of the free SQL questions on LeetCode are pretty basic but still the questions are framed very similar to how you can expect them during interviews so going through these questions will definitely help you. Having said that there are some tricky SQL questions on leetcode as well.

In this video, I will be solving 3 SQL queries so you can an understanding of how to go about solving SQL queries on leetcode. I have however solved all the free SQL questions on leetcode so I will make sure to post all of these queries in my blog.

🔴 WATCH MORE VIDEOS HERE 👇

✅ SQL Tutorial - Basic concepts:

✅ SQL Tutorial - Intermediate concepts:

✅ SQL Tutorial - Advance concepts:

✅ Practice Solving Basic SQL Queries:

✅ Practice Solving Intermediate SQL Queries:

✅ Practice Solving Complex SQL Queries:

✅ Data Analytics Career guidance:

✅ SQL Course, SQL Training Platform Recommendations:

✅ Python Tutorial:

THANK YOU,
Thoufiq

[onemanshow]

Thanks and amazing work!, Glad i found this channel.

[divyankakumari]

Its 8 in the morning, n I discovered this channel, its such an amazing channel! You make everything so simple and easy to understand. You deserve more followers and likes. May God bless you brother :)

[rachitchopra]

Need more videos like this ...You are doing a great job man. Your solutions are deployable because you explain it that way -- your teaching skill is great. And on top of that going extra mile with blogs and solutions. Loving it.

[nothingisreal]

Thank you for the great introduction. It is a little depressing that still in 2022 basic functions in different, popular relational DB systems work differently. But I guess the vendors do that to keep you from migrating away from their products.

[vikram]

Was waiting for your video since last week. Thanks for your hard work and the quality content you are creating for community. Way to go virtual Mentor :)

[laurak]

Thank you once again, Mr. Mind Reader! I was doing some queries on LeetCode last night. I can’t wait to watch this but I’m going to try those queries first. Really love your channel and so glad to be TechTFQ virtual mascot 😄🙏🏻

[fathimafarahna]

Yet another amazing content. Fantabulous... You are indeed a virtual mentor as many call you😅 God bless your efforts and intent🙏 You are helping out a tons

[LazyPvPing]

Great content! I actually have an interview in a couple of hours for a data analyst position. I appreciate all of your resources!

[rajudasari]

wowww really appreciable content !, am waiting for Stored procedure concepts

[ishitasadhukhan]

Have so much respect for the kind of content you produce. I am learning so much from you. Coming back to your channel again and again to clear my sql concepts. Thank you so much !

[NEGPOS]

Loved your Example on PIVOT and Alternate Solution Using SUM(CASE..)), YOUR EFFORTS ARE MUCH APPRECIATED !

[gouravraj]

Hi Taufiq, thanks for the informative video..
For the first question I tried using LEAD window function and it goes like below:
Select id from
(
Select *, LEAD(temperature) OVER(order by date) as LEAD_TEMP from weather
)GR
where temperature > LEAD_TEMP;
Would love to hear from you on this approach..

[tnkarunakaran]

Good video, I felt the below is much simpler with 2 way join from trip table. Q.262
with cte as (select trips.request_at,
case when trips.status like '%cancelled%' then 1 else 0 end cancelled,
1 as total
from trips join
users driver
on trips.driver_id = driver.users_id
join
users client
on trips.client_id = client.users_id
where
trips.request_at between "2013-10-01" and "2013-10-03" and
driver.banned = 'No' and
client.banned = 'No')
select
request_at as Day,
sum(cancelled)/sum(total) Cancellation_rate
from
cte
group by request_at

[hanishadua]

Cannot thank you any less for including Leet Code questions also in your amazing SQL collection!

[trishasingh]

Best SQL Channel! Please upload more practice problems

[hariprasath]

In your last kaggle dataset video I asked one question regarding pivot ...and now you answered my question for ur effort....keep going I found a gem (your channel ) ....keep rocking expecting more kaggle dataset videos hope u I'll do it 😉🤝

[kumarank]

Amazing explanation!

Concept behind each step and the way you explained was easily understandable

[MrAbouRaia]

Thank you and keep up the good work; sharing information and teaching others is a powerful way to leave your mark in life; thanks again.

[anjaan_ladka]

sir can you please generate a good set of question list for sql asked in interviews

[shivsharma]

I just want to say, whoever wants to master SQL, pls follow all his videos man!!! W3school is best for learning Basic SQL and
techTFQ for advanced SQL