Subquery in SQL | Correlated Subquery + Complete SQL Subqueries Tutorial

Visit brilliant.org/t... to get started learning STEM for free, and the first 200 people will get 20% off their annual premium subscription.
This is the SQL Subquery Tutorial video which gives you a complete understanding of subqueries in SQL. We start with explaining what a subquery is and then writing a sample SQL query containing a subquery and then explaining how SQL processes a query statement containing a subquery.
In this video we shall also look at the different types of subquery in SQL by writing SQL queries which uses these different types of subqueries. We shall look at single row subquery, multiple row sub query, single column subquery, multiple column subquery and also the correlated subqueries.
This video will also explain about the different Clauses in SQL query where it is allowed to have a subquery and we shall look at example queries to explain these differences.
Finally, we will look at the SQL commands like INSERT, UPDATE and DELETE where it is allowed to use subqueries.
Hopefully, this videos gives you a complete understanding of what subqueries are, how to use them and where to use them.
My recommended SQL Course: learnsql.com/?...
[All the scripts and SQL queries used in this video is shared in my Discord server. You can join my discord by clicking on the below link. It's FREE]
Join my Discord Server: / discord
FTC disclaimer: This video was sponsored by Brilliant.
🔴 WATCH MORE VIDEOS HERE 👇
✅ SQL Tutorial - Basic concepts:
• SQL Tutorial - Basic c...
✅ SQL Tutorial - Intermediate concepts:
• SQL Tutorial - Interme...
✅ SQL Tutorial - Advance concepts:
• SQL Tutorial - Advance...
✅ Practice Solving Basic SQL Queries:
• Practice Solving BASIC...
✅ Practice Solving Intermediate SQL Queries:
• Practice Solving INTER...
✅ Practice Solving Complex SQL Queries:
• Practice Solving COMPL...
✅ Data Analytics Career guidance:
• Data Analytics career ...
✅ SQL Course, SQL Training Platform Recommendations:
• SQL Course / Training
✅ Python Tutorial:
• Python Tutorial
THANK YOU,
Thoufiq

[@lasu5060]

Since I started my new job I've been running away from subqueries. Whenever the query reached a certain level of complexity I referred it to the data scientist, this week I faced a challenge in which I will not be able to escape from the subqueries. I watched several videos and none reached this level of detail, mainly explanation. It will help me a lot. Thank you!!! Eternally grateful.

[@inderpanda]

8:20 - Scaler subquery ( only fetches 1 row & 1 column 11:55 - Multiple Row subquery type 1 - multiple row, multiple column 18:30 - type 2 - multiple row, single column 22:18 - Co-related subqueries 37:29 - Nested subquery 46:33 - Different Clause where subquery is allowed. ( select, from, where, having ) 56:30 - SQL commands that allow subquery ( insert, update, delete )

[@Anonymous_it_is]

I haven't seen explanation of this kind anywhere, even paid courses fail to teach this way. Kudos to you man! I can't thank you enough. Magnificent content!!! SQL learners need a teacher like you.

[@techTFQ]

Thank you Rohit. glad you liked it :)

[@chaitalibanerjee5459]

True

[@rooja1000]

@@techTFQ u r such a true teacher.. who explains so clearly..n all concepts r actually easily understandable..learning so much from ur knowledge n way of teaching n explaining..thanks a lot...

[@techTFQ]

Thanks a lot Rooja 🙏🏼

[@atharvapathak3411]

Man you are the most humble teacher i ever saw, 1) You make hard things look easy 2) You know exactly where people will have doubts and the pain of those ( Not only you revive that with solutions but also give precautions ) 3) You explain things again and again without any hesitation or showing an attitude which i love the most! Everyone can see how much you want to make things understandable and easy for all. I'm really looking forward for a ' Whole Advance SQL statements using Windows function and their applications' Video Using Timestamps, extract, rank in those cases is quite tricky and I'm sure you are an Aid to those! KUDOS To You With All The Respect! Keep doing the work you do, no one else is at this level and Humbleness 🤜🏻

[@techTFQ]

Hi Atharva , It’s really pleasing to read such feedback. Thank you very very much for your kind words.. truly appreciate it and I am so happy to know you find value in my contents 🙏🏼🙏🏼🙏🏼☺️

[@yogamayaa]

Can we all take a moment to appreciate this guy, providing such amazing content for free? Hats off to you Sir. These videos are extremely useful for students like me :)

[@mullaipugazhendi3236]

YES ,REALLY AWESOME VIDEO.

[@yashpathak5837]

Q

[@independentmotivatesupport8171]

Who care

[@BCE_Abinash]

In he shared the file that he used in this video if yes pls share the link

[@nilankanpal4454]

Has done really a great job, like a perfect point of revision before the exam

[@minithyagraj6692]

For a first-timer in coding, I can say that I have understood how coding works and its all because of your brilliant way of not just explaining the queries but also explaining how SQL processes the code, which is truly amazing. Thank you and God bless!!

[@MrBrunoPING]

It's impossible to have a better video than this one about subqueries, here on KZbin. I challenge someone to present me something at this level, of didactics, examples and duration. THANK YOU TEACHER! WILL FOLLOW YOU IN ALL YOUR VIDEOS!

[@techTFQ]

Thank you for the amazing feedback bro. I am so glad you found this helpful :)

[@emrannoon2179]

I 101% agreed Bruno. I love the way he explained

[@emrannoon2179]

@@techTFQ You are rocking bro

[@veerabhadrarao258]

Awesome

[@enshk79]

You said didactics!!!!! Awesome. And I concur!!!

[@visceralcinema]

I think what's most effective about your tutorials is you don't just execute simple sql statements to illustrate a point, you actually provide real problems and demonstrate your "approach" with solving them--they're almost like "word problems" from primary school. 🤭 This has helped me understand greatly how to breakdown (future) problems.

[@gokulnath4297]

One of the finest tutor I have ever seen, Going with the pace where the every concept is covered within a short time.

[@sudarshanmhaisdhune1039]

The BEST video on subqueries on this platform. What a stuff this man have put in here. Legend!

[@vedanthasm2659]

You are one of the best SQL tutor👍 I have seen. The best part is, you take one topic and cover everything in that (Full meals 😁). No need search any other content. Super helpful... Bro!

[@techTFQ]

Thank you Vedantha for this amazing feedback :) Really motivates me to make more :)

[@IoT_]

Subscribed! I have watched tons videos on subqueries, that one made almost 100 percent clear this concept. I said "almost" just because I am not smart enough to make to the full comprehension

[@bakhtavarhafeez702]

The best subquery video I’ve come across on KZbin. Simple and easy to comprehend.

[@techTFQ]

Thank you Hafeez. glad you liked it :)

[@PrasanthKumar-pw9bk]

Stopped Surfing in internet about SQL and simply following your videos now. Its such a clear content that you deliver for us free. Thank you Sir!

[@victor_peral]

The simplicity with which you broke down complex topics is a sheer gift Keep it up

[@shaziasulthana9454]

super explanation haven't seen explanation of this kind anywhere, even paid courses fail to teach this way. Kudos to you man! I can't thank you enough. Magnificent content!!! Brilliant tutor thank you SQL learners need a teacher like you.

[@sachinsuman8536]

Hi. Your videos are great. Thanks for the effort you are making just for us to learn. I really appreciate that. While solving the UPDATE related question, I think the answer should be this: update employee e set salary=(select max(eh.salary) * 0.1 + e.salary from employee_history eh where e.dept_name=eh.dept_name) where e.dept_name in (select dept_name from department where location='Bangalore') and emp_id in (select emp_id from employee_history);

[@yashrajsingh9961]

This video was amazing, i really thing the free code camp audience would go nuts for this video, if you ever thing about donating this series

[@mahdi-saber]

I have always used ORM tools to generate SQL queries, since I was afraid about complex queries. After watching your video three times, I feel quite confident to go deeper and write down complex native SQL commands. I wish you the best for such a thoughtful content!

[@techTFQ]

Thank you Mahdi :)

[@أبويزيد-ض5ي]

40:20 I believe you have made a mistake solving this question. The total sales is not just adding up the price column, but we must multiply the price column and the quantity column to calculate how much each store made as total sales. In other words, (Quantity * Price = Total Sales). Here is my code: select store_name, sum(quantity*price) as total_sales from sales group by store_name having total_sales > avg(quantity*price); Here is the longer version: select * from (select store_name, sum(quantity*price) as total_sales from sales group by store_name) as a join (select avg(quantity*price) as avg_sales from sales) as b on a.total_sales > b.avg_sales Thanks

[@AbhishekChoudharyB]

I had the same doubt. I was wondering why no one pointed that out.

[@أبويزيد-ض5ي]

@@AbhishekChoudharyB If you started studying now aiming to get a job, change your plans. I have been looking for a job as a Data Analyst since two years and never landed a job yet. I live in the US.

[@02artiom]

@@أبويزيد-ض5ي That is sad to hear brother... What kind of certificates do you have on your resume? do you have a portfolio? Btw your arab name flipped my text LOL

[@أبويزيد-ض5ي]

@@02artiom I have a portfolio website that has some nice projects on it. I have a Bachelor’s Degree in Statistics I have IBM Professional Data Analyst Certificate. I have some certifications in SQL and Excel. If you are starting now, I advise you to run away and pick a different career because things are getting even worse. If you are still a student, pick a medical career because you will always find a job in healthcare.

[@yashiktaneja673]

​@@AbhishekChoudharyBif you see the values of quantity and price carefully u would observe the price given is not the individual product price but price of the quantity of product sold

[@itsnature5391]

hey man only person on youtube to teach sql so simplistically

[@techTFQ]

Thanks buddy , glad it helps

[@mohammedshahil4898]

A much needed one. Subqueries are the ones which i encounter the most in my work. And this video really helped me understand it even more clearly. Thank you so much Brother for yet another helpful video🙏🏻🙌🏻 👏🏻

[@techTFQ]

I am glad you liked it bro 😍 Thank you ☺️

[@eealliance5997]

Please what kind of work? I hardly find jobs where you have to make constant queries to a database.

[@ashutoshpandey1452]

I had learnt sql from various sources...but no one can match up the with your tutorial. And I prepared for the job by watching your tutorial and successfully got the job.

[@ItsWithinYou]

Superb! Thank YOU Taufiq for sharing this video. I could not find a better explanation of correlated subquery anywhere else. Now, I am very clear about this topic. I appreciate all your help!

[@techTFQ]

I am glad to hear that Rajiv :)

[@RajashreeBirajdar-n8v]

I haven't seen explanation of this kind anywhere, even paid courses fail to teach this way. such a great! really thank you so much i have cleard my all doubts

[@jayeetadas6735]

Bhaiya, your videos are just awesome. I was not good in sql. But I have started clearing interviews. Explanation is very nice and clear. Keep it up. Now step by step I will try to do it. Windows function video was really helpful. My concept is clear now.

[@techTFQ]

Thank you Jayeeta for your kind words :) Really happy to know my videos have helped 🙏

[@shilpikundu6279]

Never come across a better SQL teacher like you, every point sooo detailed! This is like a goldmine for SQL. Kudos to you for curating such awesome content!!!

[@suigeneris1242]

This is an awesome tutorial. Initially, I thought the examples were going to be redundant, but you cleared my doubts by covering the diverse uses of subqueries. Thanks for this video!

[@surbhidaksh1549]

Best Teacher with best Teaching methods and explaining each n every topic. Amazing content 😊👍

[@techTFQ]

Thanks a ton Surbhi

[@abhigoswami6668]

where were you my angel? I have attended multiple trainings for SQL but nobody explains the concept in the way you do!! Quality content with practical examples. Hats off to you for helping so many IT professionals to understand SQL in depth.

[@rainbow100_]

Wanna ask what system management did he use in this video and what do use ?

[@ndz7372]

@@rainbow100_ Pg admin on postgres

[@laurak5196]

Yes!! So glad you covered this in such a detailed video. Can’t wait to watch! Thank you so much!

[@techTFQ]

Your welcome Laura 🙏🏼 Do give me your honest feedback after you watch the video..

[@laurak5196]

@@techTFQ I enjoyed it! I do have some thoughts tho but it will take me time to compile those and send. It was a crazy day. I think subqueries are the hardest thing left for me in SQL except that I need to get more practice with window functions and also the with clause. But for subqueries I always feel like there is so much more to them. This video is helpful but I’d like to see a more general one to explain the various use cases for the placement of subqueries in the various clauses. Your real world experience such as when you mention that this is something we do all the time or this is something that is really not recommended to do and then you explain why - those comments are very helpful bc I’ve never been in this field and you are a pro so those pro tips are so valuable. So the use cases for the different placements in select, from, and where and also the performance for those for me would be also useful to have a solid understanding of. You did explain use case and performance in some detail for correlated subqueries in this one which was very useful, but I personally would like to have a better understanding of when the subquery in the from vs select vs where clause is the best choice vs forgetting the subquery altogether and going with the with clause. So, in the real world how often do you use subqueries vs the with clause and best use cases for each. Maybe a video to encompass all of that. And I think that making it very clear that any subquery in the from clause must have an alias is something that beginners don’t necessarily always know so that could perhaps be emphasized. I love that you spent an hour explaining subqueries but I could see another video stepping back in more general terms being also very useful. I hope this was helpful. Thanks for all of your good work. I also like the new background. 😊

[@laurak5196]

@techTFQ I also want to add that I’m honored that you asked for feedback. I’m not sure if that was what you were looking for. I hope you have a nice night. 🙏🏻

[@techTFQ]

Hi Laura, I loved this feedback. Kind of gave me an idea for a future video which should clear your doubts about where to use subquery and when to use it. And not just subquery but in general how to apply any SQL concepts when solving problem using SQL. But first let me thank you for this amazing feedback because I am sure this took you a very long time to compile and write them down. I completely understand your point of view and its something that a few others have asked me as well. But the thing is that, the only way you can clearly understand "where to use a subquery and when to use it and what concept of SQL to use and not use when solving a problem", all these will get clear only with experience. You need to solve many many queries, only then you will get an understanding of what to use when. But yes, I can frame some tips and tricks which can give you a better idea of what subqueries to use and where to use them and when to use them based on what kind of requirement.. Just that I can explain these by hopefully solving different types of SQL queries. Let me try to plan a video revolving this and come up with some tricks and tips. And thank you for noticing the new background 😀 Bought a new camera and some lights and just starting to learn how to make better videos. Hopefully my video visuals and editing will get better with time. Have a great day Laura and Thanks again for your amazing suggestion 🙏

[@laurak5196]

@@techTFQ Thank You for taking the time to write such a detailed reply, Thoufiq. I’m so glad the KZbin algorithm finally got some sense and started steering me to your channel. I’ve learned so much from you and I really appreciate your encouragement and guidance. It’s true what they say: You are the best SQL teacher on KZbin. I can’t believe how your subscribers have grown since I found you at under 7K. This is a testament to your knowledge and experience and not only that but your way of explaining and your patience and clarity too, along with humility, which is rare and valuable as well. I hope and trust that all of your aspirations will become reality! And thank you again for your hard work. I’m so glad the feedback was helpful. I do so appreciate your feedback and tips for me too. Have a great night and hugs to your family 🙏🏻😀

[@Euphoria-k6r]

Almighty has saved my time in exploring here and there for learning sql and landed your youtube channel directly.

[@W3Fi]

Sir, could you please make a video on elucidating when to use Join over Sub queries or vice-versa? Indeed, this is one of the major drawback for the beginner like me to deal with it in the initial stage.

[@sourabhroy8731]

Man...what an explanation. I have attended paid courses for SQL but never understood the concepts so clearly. Thank you so much and i will be soon joing your 3 Aug batch.

[@techTFQ]

Glad you liked it 🙏🏼

[@cynthiazhu473]

Subqueries are so tricky to me but this is by far the most detailed and comprehensive explanation on subquery that I've seen! Thank you soooooo much for that. Quick question on the total sales example, shouldn't we use SUM(quantity * price) to get total sales instead of just SUM(price)?

[@softwarekabaapno1]

I'm guessing the price column represents total price and not price per unit.

[@dharaneeswaran4086]

I have attended many interviews confusion with this subquery and types and you just nail it...on the money. Thank you so much!!

[@kaviyathamizharasan1451]

Splendid Video Thoufiq !! 👏👏Neat and clear explanation of all the concepts. Types of Queries you did framed to solve in this video is like a cherry on the cake. Many thanks for considering our request and working on the same. TechTFQ and Thoufiq will surely be my go-to channel/person for SQL hereafter. I wish you should be recognized and appreciated by many subscribers very soon. Please keep doing the great work 😊🙏

[@techTFQ]

Thank you so much Kaviya for your amazing feedback :) I truly appreciate you taking time to leave this feedback. I am so glad you liked the content and than you so very much for your kind wishes :)

[@kaviyathamizharasan1451]

@@techTFQ Pleasure is all mine 😊🙏

[@snehasn91]

You are really good. I go through all your SQL videos whenever I need to go for interviews, and it always works for me. Here I am back again to watch your videos as I am in middle of a job search! Wish me luck. Thank you so much for these wonderful videos, they are the best!

[@techTFQ]

Thank you Sneha and wishing you all the best 👍

[@yomtovaharoni]

well detailed and great explanation of an important topic in SQL! I think there might be a mistake in the question with the number of units sold by each store. the average is (3+2+11+6)/4 and is far greater from 2 which you remarked :)

[@MalayKhandkar]

well noted! even i made that observation

[@bayesed]

Yes, I dont know why he made this mistake because in the avg(prive) exercise he said that you have to group them and then calculate the avg().

[@youssefa7172]

@@bayesed in that example he said across all stores

[@BabalolaMalik-jd5ut]

I also observe that as well 👍 I think that's a mistake We should be left with 2 stores

[@surajtiwari9078]

Yes ! As the avg price for all stores coming as 2200.0

[@hiulaicheng3781]

This is the best SQL video I have ever seen. Thx

[@shivsharma9153]

This is an amazing video..thank you for helping students like me!!!!!!!!!❤❤❤❤❤❤❤❤

[@techTFQ]

I am so glad to hear that Shiv .. Thanks for your feedback and I am glad this helped ☺️🙏🏼

[@paulchukwuka6653]

You are just the best, just know that i am learning alot from you. Much respect from NIGERIA

[@SambitKuSahu]

Thank you so much for your valuable info on subquery.

[@techTFQ]

Your welcome Sambit 🙏🏼

[@satishkumar-lh6kz]

your teaching is much better than many celebrity trainers, great teaching, thank you for wonderful explanation

[@shohelkasamji11]

Your explanation is amazing, really love watching your videos as I get to learn so much and they’re not boring either. Thank you so much for sharing this. Keep up the amazing work. 👊🏽👍🏽

[@sonu2op747]

We can say that this is the most requested video by all subscribers and I took a course from a website but the way you explain this content is much better than any paid course I love your videos and the way to explain all this. Much appreciated sir.

[@itikalaneelu9126]

i have gone through hundreds of videos on Joins but unable to get the knowledge. With just one video i became expert in joins :) this is because of you sir . Keep up the good work. I will be following your videos going forward. excellent explaination without any confusion.

[@shaffumehta1405]

best content quality on this plateform ....amazing sir and god bless you sir and thanku so much for sharing your knowledge so deeply and nicely...it really helped a lot of students

[@techTFQ]

Thank you Shaffu 🙏🏼 Glad you liked it

[@32_ec_divagupta22]

it is great vedio for understanding sql subqueries thank u sir .....

[@pam9367]

Thalaiva u r great... learned more thanks 🤞🙌

[@techTFQ]

haha Thank you buddy 😍

[@kennedymatanda4972]

I can download this video a thousand times just because of the quality of the presentation!. Good work bro.

[@aurojitmishra2542]

Timestamp 55:30 The average will be 5.5 (11+2+6+3/4) . But the query resulted as 2.2. Any thoughts?

[@aryar7510]

Even I have the same thoughts

[@techTFQ]

It is 2.2 because it is the avg of quantity from the entire sales table.. You avg of 5.5 is the avg when considering the group by query .. Difficult to explain in comment but if you read the query statement properly and try it out yourself, you will come to know

[@aurojitmishra2542]

Thanks for the explanation 🙌

[@paulhowrang]

@@techTFQ True but it defies logic, if we have multiple entries of the same store, you cant take average without summing from individual stores, moreover, this cant be just ignored because it is for learning purpose, the query will become more involved, to a more attentive student current case seems confusing

[@yoo0angg]

I noticed this right away as well. I am very much an SQL newbie but the average of 2.2 is taking the full sales table into account with multiple store rows and not aggregating the total sales for each store. It is incorrect. You have to take the average using the group by clause.

[@damodardy5761]

IT IS ONE OF THE BEST VIDEOS ABOUT SUBQUERY. THE EXPLANATION WAS CRISP AND CLEAR. THANKS FOR ALL YOUR EFFORTS

[@techTFQ]

Thank you Damodar.. glad you liked it

[@Pankaj_Menaria_Bawa]

Most awaited video I was waiting for...thank you sir.. following you on LinkedIn ❤️

[@techTFQ]

Thank you Pankaj 🙏🏼 I hope you like this one

[@Pankaj_Menaria_Bawa]

@@techTFQ yes sir it helped me a lot ❣️

[@techTFQ]

I am glad to hear that ☺️

[@itikalaneelu9126]

This video is far far better than any videos in entire youtube

[@harithaatla8937]

thank you so much for clear explanation

[@techTFQ]

Your welcome Haritha 🙏🏼 Glad you liked it

[@KetakiGadgil_15]

Hi, thanks for the informative video. At 28:11, alternate solution is select * from employee emp join (select dept_id,avg(salary) as avg_sal from employee group by dept_id) avg_sal on emp.dept_id = avg_sal.dept_id and emp.salary > avg_sal.avg_sal

[@satheeshkumarak6708]

@ 1:06:06 , in line number 164, I think it should set salary = (select salary + (max(salary*0.1)) Each Employee's salary should be incremented from his own salary and not from the maximum salary. The maximum salary is to be considered only for calculation of the increment. Am I right?

[@techTFQ]

Nope.. the question was to provide increment based on the max salary not considering each employee salary

[@satheeshkumarak6708]

@@techTFQ , so based on your logic, Sir, everyone from a department will be having equal salary, right?

[@techTFQ]

Exactly

[@jatinyadav8960]

Best video on practical Implementation of Sub Queries on KZbin

[@techTFQ]

Thank you Jatin

[@Zenith40450]

Nice explanation...Helpful content...👍👍👍

[@techTFQ]

Thank you Ambar 🙏🏼

[@Anilkumar-reddy]

Take a bow to these guy for him amazing work. Thank You Toufiq for all your videos. Please continue your work. will always support you

[@saurabhrajput7482]

Sir, please provide us with the same table are you using during the written query. Thanks for uploading this amazing video.

[@techTFQ]

Yeah I’ll share all these scripts in my discord server .. so you can join my discord using the link in video description

[@saurabhrajput7482]

Ok Thanks again 👏

[@kamalbashir786]

@@techTFQ Sir,when you share the script on Discord server. as I just checked I didn't found out script there

[@techTFQ]

It’s there in announcement channel.. U can ask other in discord if u can’t find it

[@harichandrajaiswal8804]

It's impossible to have a better video than this one about subqueries u are the best sirr

[@techTFQ]

Thank you :) Glad this helped

[@velap2129]

Saving this to my folder and I am sure I m going to watch this multiple times... Going to be very useful... Thanks Btw, could you have a video explaining how to analyze the performance of different queries that accomplish same result but performance is different due to the way it is handled

[@techTFQ]

Thank you Vela :) I hope you like it. As for performance of different queries, ill make separate video about it.

[@velap2129]

@@techTFQ certainly, like all the videos you make. It really shows how much efforts you put into it to make it very clear to everyone. I'm in no way connected to sqls at work, but got interested at after seeing your videos.

[@techTFQ]

Amazing vela , I am so glad to read this .. Thank you 🙏🏼

[@mango-strawberry]

scalar subquery multiple row subquery correlated subquery 37:49 Nested Subquery 46:24 with clause 46:38 different clauses in SQL where subquery is used select from where having 50:50 subquery inside select clause avoid using subquery with SELECT clause 56:32 sql commands which allow subquery INSERT UPDATE 1:03:30 DELETE 1:08:29

[@readistreet9383]

thanks a lot for the videos, you explain it very well!

[@techTFQ]

Glad you like them bro!

[@deepti.sharma.]

You are such a great teacher and explain hard topics so easily

[@techTFQ]

Glad you think so!

[@shivambajpai5919]

super video on SQL subqueries . A complete take on subqueries with practical examples. Definitely the Best Video on whole youtube even better than paid classes .

[@mangeshputran6593]

Thank you for the amazing content.

[@techTFQ]

Your welcome bro. glad you liked it

[@VijayNaramalli]

U are the best tutor I have never seen in my life

[@fathimafarahna2633]

Amazing 👏

[@techTFQ]

Thank you 😍

[@rajeshjadhav2761]

Best SQL video i have been through...The Way making us to understand and the language used can help even non tech guys like me to understand easily...Thank you so much... keep doing....

[@techTFQ]

Glad you liked it Rajesh

[@urvindarkaur0278]

Hi , what an amazing effort!! THNAKS A MILLION!! Totally worth it. Also, kindly share the content notes if you have created for these stuff as it will be easy to practise alongside

[@techTFQ]

Thank you :) I have shared the dataset and all the scripts in my discord. link to join my discord is in video description

[@arunsingh768]

U r really a good mentor on SQL. Very good concept. I have learnt to many things from ur vedio

[@AsadAli-wi1xs]

Sir please make the video on sql store procedure and trigger...

[@techTFQ]

Sure bro will do it

[@iraviarya]

I m a sql freak, liked your stuff, easy n simple

[@techTFQ]

Glad you like this :)

[@nisha6165]

You are a great teacher 🎉 wonderful method of teaching 😀 pls try to be Active on this platform because a teacher like u is need for everyone.. If u know sql data tools kindly post it when u r free.. Thanks for the great work♥️ Because free education is the world's best education 🎈

[@techTFQ]

Thank you Nisha ☺️🙏🏼 I am glad you value my contents so much .. and yeah I want to post more video on KZbin.. working towards it.. May I know what u mean by data tools?

[@nisha6165]

@@techTFQ Data tools like SQL SERVER INTEGRATION SERVICES (SSIS), ANALYSIS SERVICES(SSAS),REPORTING SERVICES (SSRS). Thanks for your reply 🎈

[@techTFQ]

Oh ok got it.. Noted and let me consider the suggestion

[@nisha6165]

@@techTFQ Thanks 😊

[@chandrikalakshmikandan8895]

First of all thanks to explain in deeply in this concept. You make hard things to teach in easy way. Hats off to that.

[@puttaezra]

CAN I KNOW THE REASON WHY U HAVE DELETED PLAYLIST ?

[@techTFQ]

What’s wrong with you man.. who said I deleted playlist? I have renamed the playlist hence may be the old link with old playlist name does not work.. just go to the channel and see all playlist there.. At least think twice before posting such comments

[@puttaezra]

@@techTFQ SORRY BROTHER , COULD YOU OFFER YOUR COURSE FOR FREE , BECAUSE I AM VERY ENTHUSIASTIC TO LEARN SQL, PYTHON .RIGHT NOW I AM A STUDENT , COULD YOU HELP ME BROTHER. RIGHT I AM STRUGGLING WITHOUT JOB.

[@ansu0406]

Thanks alot for ur contribution​@@techTFQ

[@Beant1980]

The best Video on KZbin for -> Correlated Subquery, Thanks

[@techTFQ]

Glad you think so! Thank you :)

[@rojalibiswal8975]

Dataset please

[@manithsuy286]

I've been having such a hard time with subqueries on how to write them, understanding them, etc. You've helped a lot thanks.

[@kushagrasharma5944]

Please can you share the dataset

[@techTFQ]

I have shared the dataset in my discord channel. you can join my discord using the link present in video description

[@tamilarasic1159]

you are a GEM. I never find a place to learn all these variations of sub query. Much useful video. Thank you so much for this wonderful lecture.

[@adityaraj-j9k4t]

it was an amazing tutorial, all the subqueries were in a single video. learnt a lot, it will take time to process all these.

[@poshpoise2526]

when someone is too good at explaining its kind of relaxing to the mind.. and i start feeling sleepy..it happens all the time.. u explained it sosososoosososososoosoo well... i understood it... but after finishing it i feel like i need to take a nap..hahahaha..

[@brigienshilpa8034]

Awesome thanks a lot ,i had lot of doubt in subquery but after watching your video i am confident that I too can write query using subquery

[@supersql8406]

Fantastic! This video even helps professionals SQL writer like me who needs a quick refresher!

[@bilalshahbazakmal2543]

I really love teaching style every single step explain very easily

[@sourabhchoudhary8908]

this is really really great best explanation on subqueries

[@pravinsonawane5799]

"Fantastic explanation! Your teaching style made the concept of subqueries so much clearer. I really appreciate the time and effort you put into breaking down the material. Thanks for another insightful and helpful video!"

[@RecordColl]

Thank you! Using the EXISTS with a subquery has helped me resolve a report request that was stumping me.

[@techTFQ]

Glad to hear that :)

[@1607priyanka]

Thank you so much. This was very helpful 😊

[@vuphan2956]

This is a greatest ever video about subqueries, very easy to understand and well explanation. Thank you so much!

[@farazrashid7]

At first i thought that the video is too long now i wanna live in it, it's very useful.

[@vinu0023]

Same here. But I learnt a lot. Subqueries made easy in this video

[@AnilKumar-ve2yl]

best explanation i have ever seen , keep it up , it was very helpful to know that there are endless possibilities to solve a complex problem.

[@glstnlev]

You are the king. To me it’s the most difficult part of learning SQL. Thank you!

[@techTFQ]

Thank you Levon 🙏🏼 Glad you liked it

[@SoniaD-fj1nr]

this is the best vedio have seen so far which made me think that even sql complex queries are easy which i thought was difficult.

[@luckykumar1665]

At 54:21, if we calculate the average unit sold by 4 departments = (11+2+6+3)/4 = 5.5, just confused by the result we are getting from the query at 54:55 select avg(quantity) from sales; here we got 2 as avg....... can we use this one if not then please explain? I am confused. select avg(avg_count.quantity) from (select store_name, sum(quantity) as quantity from sales group by store_name) as avg_count

[@lynchian275]

Wonderfully explained. God bless you, Thoufiq!