0:00 - Introduction 1:05 - Nested Subquery 1:37 - Example 6:54 - Nested Subquery 9:39 - Correlated Subquery 12:29 - Joins Full course of DBMS https://www.youtube.com/playlist?list=PLxCzCOWd7aiFAN6I8CuViBuCdJgiOkT2YSubscribe to our new channel: https://www.youtube.com/c/GateSmashersPlus Other subject playlist Link: --------------------------------------------------------------------------------------------------------------------------------------Design a nd Analysis of algorithms (DAA): https://www.youtube.com/playlist?list=PLxCzCOWd7aiHcmS4i14bI0VrMbZTUvlTaOperating System: https://www.youtube.com/playlist?list=PLxCzCOWd7aiGz9donHRrE9I3Mwn6XdP8p Theory of Computation https://www.youtube.com/playlist?list=PLxCzCOWd7aiFM9Lj5G9G_76adtyb4ef7iArtificial Intelligence: https://www.youtube.com/playlist?list=PLxCzCOWd7aiHGhOHV-nwb0HR5US5GFKFIComputer Architecture: https://www.youtube.com/playlist?list=PLxCzCOWd7aiHMonh3G6QNKq53C6oNXGrXComputer Networks: https://www.youtube.com/playlist?list=PLxCzCOWd7aiGFBD2-2joCpWOLUrDLvVV_Structured Query Language (SQL): https://www.youtube.com/playlist?list=PLxCzCOWd7aiHqU4HKL7-SITyuSIcD93idDiscrete Mathematics: https://www.youtube.com/playlist?list=PLxCzCOWd7aiH2wwES9vPWsEL6ipTaUSl3Compiler Design: https://www.youtube.com/playlist?list=PLxCzCOWd7aiEKtKSIHYusizkESC42diycNumber System: https://www.youtube.com/playlist?list=PLxCzCOWd7aiFOet6KEEqDff1aXEGLdUznCloud Computing & BIG Data: https://www.youtube.com/playlist?list=PLxCzCOWd7aiHRHVUtR-O52MsrdUSrzuy4Software Engineering: https://www.youtube.com/playlist?list=PLxCzCOWd7aiEed7SKZBnC6ypFDWYLRvB2Data Structure: https://www.youtube.com/playlist?list=PLxCzCOWd7aiEwaANNt3OqJPVIxwp2ebiTGraph Theory: https://www.youtube.com/playlist?list=PLxCzCOWd7aiG0M5FqjyoqB20Edk0tyzVtProgramming in C: https://www.youtube.com/playlist?list=PLxCzCOWd7aiGmiGl_DOuRMJYG8tOVuapB --------------------------------------------------------------------------------------------------------------------------------------- Our Social Media: Subscribe us on YouTube-https://www.youtube.com/gatesmashersTelegram Channel Link: https://telegram.me/gatesmashersofficial Like Our page on Facebook - https://www.facebook.com/gatesmashers Follow us on Instagram-https://www.instagram.com/gate.smashers --------------------------------------------------------------------------------------------------------------------------------------A small donation would help us continue making GREAT Lectures for you.Be a Member & Give your Support on bellow link : https://www.youtube.com/channel/UCJihyK0A38SZ6SdJirEdIOw/joinUPI: gatesmashers@aplFor any other Contribution like notes pdfs, feedback ,suggestion etc gatesmashersconribution@gmail.comFor Business Query gatesmashers2018@gmail.com