In this video we will learn SUBQUERY in SQL with example
Example - find employee details from a particular department
0:00 explanation
3:00 example 1
13:00 example 2
Sqlite studio is used to run SQL queries . please find the below link to learn Sqlite studio installation video
Also the DB file used in tutorial to practice
GROUP BY CLAUSE :- https://youtu.be/27qn_MhaKXs
Sqlite Studio Video :- https://youtu.be/Yi6CiRQQXWc
Inner Join Video :- https://youtu.be/UrpBQmypa3k
Self Join Video :- https://youtu.be/ppM3o_-y1UA
DB File :- https://drive.google.com/file/d/1oxXhmkV4uKDPXqjTEnWje5Ix--efstuJ/view?usp=sharing
