codewithvenky
codewithvenky
  • Видео 57
  • Просмотров 7 966
Crack SQL Interviews |Part 36 | Advanced Select & Joins-7|#faang #sqlinterviewquestions #leetcodesql
Question Link : leetcode.com/problems/last-person-to-fit-in-the-bus/description/?envType=study-plan-v2&envId=top-sql-50
Welcome to Part 36 of our "Crack SQL Interviews in 50 Questions" series! In this video, we dive deep into one of the most fundamental aspects of SQL-Sorting and Grouping. Whether you're preparing for a SQL interview or brushing up on your database querying skills, we've got you covered.
We’ll walk through essential Basic Joins statement questions commonly asked in SQL interviews, focusing on how to retrieve, filter, and manipulate data efficiently. All questions are based on LeetCode challenges, so you’ll be practicing with real-world problems.
📌 What You'll Learn:
How to us...
Просмотров: 16

Видео

Crack SQL Interviews |Part 35 | Advanced Select & Joins-6|#faang #sqlinterviewquestions #leetcodesql6:27Crack SQL Interviews |Part 35 | Advanced Select & Joins-6|#faang #sqlinterviewquestions #leetcodesql
Crack SQL Interviews |Part 35 | Advanced Select & Joins-6|#faang #sqlinterviewquestions #leetcodesql
Просмотров 127 часов назад
Question Link : leetcode.com/problems/last-person-to-fit-in-the-bus/?envType=study-plan-v2&envId=top-sql-50 Welcome to Part 35 of our "Crack SQL Interviews in 50 Questions" series! In this video, we dive deep into one of the most fundamental aspects of SQL-Sorting and Grouping. Whether you're preparing for a SQL interview or brushing up on your database querying skills, we've got you covered. W...
Crack SQL Interviews |Part 34 | Advanced Select & Joins-5|#faang #sqlinterviewquestions #leetcodesql9:34Crack SQL Interviews |Part 34 | Advanced Select & Joins-5|#faang #sqlinterviewquestions #leetcodesql
Crack SQL Interviews |Part 34 | Advanced Select & Joins-5|#faang #sqlinterviewquestions #leetcodesql
Просмотров 129 часов назад
Question Link : leetcode.com/problems/product-price-at-a-given-date/?envType=study-plan-v2&envId=top-sql-50 Welcome to Part 34 of our "Crack SQL Interviews in 50 Questions" series! In this video, we dive deep into one of the most fundamental aspects of SQL-Sorting and Grouping. Whether you're preparing for a SQL interview or brushing up on your database querying skills, we've got you covered. W...
Python Basics : Mastering While Loop | #python #pythonprogramming #pythontutorial #learnpython13:20Python Basics : Mastering While Loop | #python #pythonprogramming #pythontutorial #learnpython
Python Basics : Mastering While Loop | #python #pythonprogramming #pythontutorial #learnpython
Просмотров 1212 часов назад
Welcome to our Python Basics series! In this video, we'll be covering one of the most essential functions in Python: the While Loop. Whether you're brand new to programming or just getting started with Python, understanding how to use While Loop is the perfect first step. 🔹 What You'll Learn: How to use the While Loop in Python Different ways to format strings and display output Common mistakes...
Crack SQL Interviews |Part 33 | Advanced Select & Joins-4|#faang #sqlinterviewquestions #leetcodesql9:45Crack SQL Interviews |Part 33 | Advanced Select & Joins-4|#faang #sqlinterviewquestions #leetcodesql
Crack SQL Interviews |Part 33 | Advanced Select & Joins-4|#faang #sqlinterviewquestions #leetcodesql
Просмотров 3712 часов назад
Question Link : leetcode.com/problems/consecutive-numbers/?envType=study-plan-v2&envId=top-sql-50 Welcome to Part 32 of our "Crack SQL Interviews in 50 Questions" series! In this video, we dive deep into one of the most fundamental aspects of SQL-Sorting and Grouping. Whether you're preparing for a SQL interview or brushing up on your database querying skills, we've got you covered. We’ll walk ...
Python : Mastering Conditional Statements | #python #pythonprogramming #pythontutorial #learnpython8:01Python : Mastering Conditional Statements | #python #pythonprogramming #pythontutorial #learnpython
Python : Mastering Conditional Statements | #python #pythonprogramming #pythontutorial #learnpython
Просмотров 2114 часов назад
Welcome to our Python Basics series! In this video, we'll be covering one of the most essential functions in Python: the Conditional Statements. Whether you're brand new to programming or just getting started with Python, understanding how to use Conditional Statements is the perfect first step. 🔹 What You'll Learn: How to use the Conditional Statements in Python Different ways to format string...
Crack SQL Interviews |Part 32 | Advanced Select & Joins-3|#faang #sqlinterviewquestions #leetcodesql4:04Crack SQL Interviews |Part 32 | Advanced Select & Joins-3|#faang #sqlinterviewquestions #leetcodesql
Crack SQL Interviews |Part 32 | Advanced Select & Joins-3|#faang #sqlinterviewquestions #leetcodesql
Просмотров 2914 часов назад
Question Link : leetcode.com/problems/triangle-judgement/?envType=study-plan-v2&envId=top-sql-50 Welcome to Part 32 of our "Crack SQL Interviews in 50 Questions" series! In this video, we dive deep into one of the most fundamental aspects of SQL-Sorting and Grouping. Whether you're preparing for a SQL interview or brushing up on your database querying skills, we've got you covered. We’ll walk t...
Crack SQL Interviews |Part 31 | Advanced Select & Joins-2|#faang #sqlinterviewquestions #leetcodesql4:58Crack SQL Interviews |Part 31 | Advanced Select & Joins-2|#faang #sqlinterviewquestions #leetcodesql
Crack SQL Interviews |Part 31 | Advanced Select & Joins-2|#faang #sqlinterviewquestions #leetcodesql
Просмотров 3514 часов назад
Question Link : leetcode.com/problems/primary-department-for-each-employee/?envType=study-plan-v2&envId=top-sql-50 Welcome to Part 31 of our "Crack SQL Interviews in 50 Questions" series! In this video, we dive deep into one of the most fundamental aspects of SQL-Sorting and Grouping. Whether you're preparing for a SQL interview or brushing up on your database querying skills, we've got you cov...
Python Basics: Mastering Operators | #python #pythonprogramming #pythontutorial #learnpython18:33Python Basics: Mastering Operators | #python #pythonprogramming #pythontutorial #learnpython
Python Basics: Mastering Operators | #python #pythonprogramming #pythontutorial #learnpython
Просмотров 10219 часов назад
Welcome to our Python Basics series! In this video, we'll be covering one of the most essential functions in Python: the Operators. Whether you're brand new to programming or just getting started with Python, understanding how to use Operators is the perfect first step. 🔹 What You'll Learn: How to use the Operators in Python Different ways to format strings and display output Common mistakes to...
Crack SQL Interviews |Part 30 | Advanced Select & Joins-1|#faang #sqlinterviewquestions #leetcodesql7:36Crack SQL Interviews |Part 30 | Advanced Select & Joins-1|#faang #sqlinterviewquestions #leetcodesql
Crack SQL Interviews |Part 30 | Advanced Select & Joins-1|#faang #sqlinterviewquestions #leetcodesql
Просмотров 15919 часов назад
Question Link : leetcode.com/problems/the-number-of-employees-which-report-to-each-employee/?envType=study-plan-v2&envId=top-sql-50 Welcome to Part 30 of our "Crack SQL Interviews in 50 Questions" series! In this video, we dive deep into one of the most fundamental aspects of SQL-Sorting and Grouping. Whether you're preparing for a SQL interview or brushing up on your database querying skills, ...
Python Basics: Mastering Data Types | #python #pythonprogramming #pythontutorial #learnpython18:42Python Basics: Mastering Data Types | #python #pythonprogramming #pythontutorial #learnpython
Python Basics: Mastering Data Types | #python #pythonprogramming #pythontutorial #learnpython
Просмотров 67День назад
Welcome to our Python Basics series! In this video, we'll be covering one of the most essential functions in Python: the Data Types. Whether you're brand new to programming or just getting started with Python, understanding how to use Data Types is the perfect first step. 🔹 What You'll Learn: How to use the Data Types in Python Different ways to format strings and display output Common mistakes...
Crack SQL Interviews |Part 29 | Sorting and Grouping - 7 |#faang #sqlinterviewquestions #leetcodesql3:38Crack SQL Interviews |Part 29 | Sorting and Grouping - 7 |#faang #sqlinterviewquestions #leetcodesql
Crack SQL Interviews |Part 29 | Sorting and Grouping - 7 |#faang #sqlinterviewquestions #leetcodesql
Просмотров 25День назад
Question Link : leetcode.com/problems/customers-who-bought-all-products/?envType=study-plan-v2&envId=top-sql-50 Welcome to Part 29 of our "Crack SQL Interviews in 50 Questions" series! In this video, we dive deep into one of the most fundamental aspects of SQL-Sorting and Grouping. Whether you're preparing for a SQL interview or brushing up on your database querying skills, we've got you covere...
Python Basics: Mastering Input Function | #python #pythonprogramming #pythontutorial #learnpython29:43Python Basics: Mastering Input Function | #python #pythonprogramming #pythontutorial #learnpython
Python Basics: Mastering Input Function | #python #pythonprogramming #pythontutorial #learnpython
Просмотров 78День назад
Welcome to our Python Basics series! In this video, we'll be covering one of the most essential functions in Python: the input() function. Whether you're brand new to programming or just getting started with Python, understanding how to use input() is the perfect first step. 🔹 What You'll Learn: How to use the input() function in Python Different ways to format strings and display output Common...
Python Basics: Mastering the Print Function | #Python#PythonProgramming#PythonTutorial#LearnPython8:35Python Basics: Mastering the Print Function | #Python#PythonProgramming#PythonTutorial#LearnPython
Python Basics: Mastering the Print Function | #Python#PythonProgramming#PythonTutorial#LearnPython
Просмотров 66День назад
Welcome to our Python Basics series! In this video, we'll be covering one of the most essential functions in Python: the print() function. Whether you're brand new to programming or just getting started with Python, understanding how to use print() is the perfect first step. 🔹 What You'll Learn: How to use the print() function in Python Different ways to format strings and display output Common...
Crack SQL Interviews |Part 28 | Sorting and Grouping - 6 |#faang #sqlinterviewquestions #leetcodesql3:31Crack SQL Interviews |Part 28 | Sorting and Grouping - 6 |#faang #sqlinterviewquestions #leetcodesql
Crack SQL Interviews |Part 28 | Sorting and Grouping - 6 |#faang #sqlinterviewquestions #leetcodesql
Просмотров 35День назад
Question Link : leetcode.com/problems/biggest-single-number/?envType=study-plan-v2&envId=top-sql-50 Welcome to Part 28 of our "Crack SQL Interviews in 50 Questions" series! In this video, we dive deep into one of the most fundamental aspects of SQL-Sorting and Grouping. Whether you're preparing for a SQL interview or brushing up on your database querying skills, we've got you covered. We’ll wal...
Crack SQL Interviews |Part 27 | Sorting and Grouping - 5 |#faang #sqlinterviewquestions #leetcodesql3:04Crack SQL Interviews |Part 27 | Sorting and Grouping - 5 |#faang #sqlinterviewquestions #leetcodesql
Crack SQL Interviews |Part 27 | Sorting and Grouping - 5 |#faang #sqlinterviewquestions #leetcodesql
Просмотров 3214 дней назад
Crack SQL Interviews |Part 27 | Sorting and Grouping - 5 |#faang #sqlinterviewquestions #leetcodesql
Crack SQL Interviews |Part 26 | Sorting and Grouping - 4 |#faang #sqlinterviewquestions #leetcodesql2:31Crack SQL Interviews |Part 26 | Sorting and Grouping - 4 |#faang #sqlinterviewquestions #leetcodesql
Crack SQL Interviews |Part 26 | Sorting and Grouping - 4 |#faang #sqlinterviewquestions #leetcodesql
Просмотров 12214 дней назад
Crack SQL Interviews |Part 26 | Sorting and Grouping - 4 |#faang #sqlinterviewquestions #leetcodesql
Crack SQL Interviews |Part 25 | Sorting and Grouping - 3 |#faang #sqlinterviewquestions #leetcodesql5:59Crack SQL Interviews |Part 25 | Sorting and Grouping - 3 |#faang #sqlinterviewquestions #leetcodesql
Crack SQL Interviews |Part 25 | Sorting and Grouping - 3 |#faang #sqlinterviewquestions #leetcodesql
Просмотров 10114 дней назад
Crack SQL Interviews |Part 25 | Sorting and Grouping - 3 |#faang #sqlinterviewquestions #leetcodesql
Crack SQL Interviews |Part 24 | Sorting and Grouping - 2 |#faang #sqlinterviewquestions #leetcodesql3:51Crack SQL Interviews |Part 24 | Sorting and Grouping - 2 |#faang #sqlinterviewquestions #leetcodesql
Crack SQL Interviews |Part 24 | Sorting and Grouping - 2 |#faang #sqlinterviewquestions #leetcodesql
Просмотров 6614 дней назад
Crack SQL Interviews |Part 24 | Sorting and Grouping - 2 |#faang #sqlinterviewquestions #leetcodesql
Crack SQL Interviews |Part 23 | Sorting and Grouping - 1 |#faang #sqlinterviewquestions #leetcodesql3:19Crack SQL Interviews |Part 23 | Sorting and Grouping - 1 |#faang #sqlinterviewquestions #leetcodesql
Crack SQL Interviews |Part 23 | Sorting and Grouping - 1 |#faang #sqlinterviewquestions #leetcodesql
Просмотров 9821 день назад
Crack SQL Interviews |Part 23 | Sorting and Grouping - 1 |#faang #sqlinterviewquestions #leetcodesql
Crack SQL Interviews | Part 22 | Basic Aggregate - 8 | #faang #sqlinterviewquestions #leetcodesql7:28Crack SQL Interviews | Part 22 | Basic Aggregate - 8 | #faang #sqlinterviewquestions #leetcodesql
Crack SQL Interviews | Part 22 | Basic Aggregate - 8 | #faang #sqlinterviewquestions #leetcodesql
Просмотров 12121 день назад
Crack SQL Interviews | Part 22 | Basic Aggregate - 8 | #faang #sqlinterviewquestions #leetcodesql
Crack SQL Interviews | Part 21 | Basic Aggregate - 7 | #faang #sqlinterviewquestions #leetcodesql7:49Crack SQL Interviews | Part 21 | Basic Aggregate - 7 | #faang #sqlinterviewquestions #leetcodesql
Crack SQL Interviews | Part 21 | Basic Aggregate - 7 | #faang #sqlinterviewquestions #leetcodesql
Просмотров 11721 день назад
Crack SQL Interviews | Part 21 | Basic Aggregate - 7 | #faang #sqlinterviewquestions #leetcodesql
Crack SQL Interviews | Part 20 | Basic Aggregate - 6 | #faang #sqlinterviewquestions #leetcodesql9:21Crack SQL Interviews | Part 20 | Basic Aggregate - 6 | #faang #sqlinterviewquestions #leetcodesql
Crack SQL Interviews | Part 20 | Basic Aggregate - 6 | #faang #sqlinterviewquestions #leetcodesql
Просмотров 8021 день назад
Crack SQL Interviews | Part 20 | Basic Aggregate - 6 | #faang #sqlinterviewquestions #leetcodesql
Crack SQL Interviews | Part 19 | Basic Aggregate - 5 | #faang #sqlinterviewquestions #leetcodesql8:03Crack SQL Interviews | Part 19 | Basic Aggregate - 5 | #faang #sqlinterviewquestions #leetcodesql
Crack SQL Interviews | Part 19 | Basic Aggregate - 5 | #faang #sqlinterviewquestions #leetcodesql
Просмотров 9621 день назад
Crack SQL Interviews | Part 19 | Basic Aggregate - 5 | #faang #sqlinterviewquestions #leetcodesql
Crack SQL Interviews | Part 18 | Basic Aggregate - 4 | #faang #sqlinterviewquestions #leetcodesql5:50Crack SQL Interviews | Part 18 | Basic Aggregate - 4 | #faang #sqlinterviewquestions #leetcodesql
Crack SQL Interviews | Part 18 | Basic Aggregate - 4 | #faang #sqlinterviewquestions #leetcodesql
Просмотров 10521 день назад
Crack SQL Interviews | Part 18 | Basic Aggregate - 4 | #faang #sqlinterviewquestions #leetcodesql
Crack SQL Interviews | Part 17 | Basic Aggregate - 3 | #faang #sqlinterviewquestions #leetcodesql5:44Crack SQL Interviews | Part 17 | Basic Aggregate - 3 | #faang #sqlinterviewquestions #leetcodesql
Crack SQL Interviews | Part 17 | Basic Aggregate - 3 | #faang #sqlinterviewquestions #leetcodesql
Просмотров 7521 день назад
Crack SQL Interviews | Part 17 | Basic Aggregate - 3 | #faang #sqlinterviewquestions #leetcodesql
Crack SQL Interviews | Part 16 | Basic Aggregate - 2 | #faang #sqlinterviewquestions #leetcodesql7:53Crack SQL Interviews | Part 16 | Basic Aggregate - 2 | #faang #sqlinterviewquestions #leetcodesql
Crack SQL Interviews | Part 16 | Basic Aggregate - 2 | #faang #sqlinterviewquestions #leetcodesql
Просмотров 11428 дней назад
Crack SQL Interviews | Part 16 | Basic Aggregate - 2 | #faang #sqlinterviewquestions #leetcodesql
Crack SQL Interviews | Part 15 | Basic Aggregate - 1 | #faang #sqlinterviewquestions #leetcodesql3:40Crack SQL Interviews | Part 15 | Basic Aggregate - 1 | #faang #sqlinterviewquestions #leetcodesql
Crack SQL Interviews | Part 15 | Basic Aggregate - 1 | #faang #sqlinterviewquestions #leetcodesql
Просмотров 12728 дней назад
Crack SQL Interviews | Part 15 | Basic Aggregate - 1 | #faang #sqlinterviewquestions #leetcodesql
Crack SQL Interviews | Part 14 | BASIC JOINS - 9 Statements Explained in 50 LeetCode Questions | SQL9:19Crack SQL Interviews | Part 14 | BASIC JOINS - 9 Statements Explained in 50 LeetCode Questions | SQL
Crack SQL Interviews | Part 14 | BASIC JOINS - 9 Statements Explained in 50 LeetCode Questions | SQL
Просмотров 189Месяц назад
Crack SQL Interviews | Part 14 | BASIC JOINS - 9 Statements Explained in 50 LeetCode Questions | SQL
Crack SQL Interviews | Part 13 | BASIC JOINS - 8 Statements Explained in 50 LeetCode Questions | SQL5:13Crack SQL Interviews | Part 13 | BASIC JOINS - 8 Statements Explained in 50 LeetCode Questions | SQL
Crack SQL Interviews | Part 13 | BASIC JOINS - 8 Statements Explained in 50 LeetCode Questions | SQL
Просмотров 136Месяц назад
Crack SQL Interviews | Part 13 | BASIC JOINS - 8 Statements Explained in 50 LeetCode Questions | SQL

Комментарии

  • @Manifestion_kannada
    @Manifestion_kannada 8 дней назад

    I thank you my bottom of my heart These kind of advance questions helping me and buliding confidence in my self to solve SQL queries.

    • @codewithvenkym
      @codewithvenkym 8 дней назад

      Thank you @manifestion_kannada keep learning and please do support by sharing channel with your friends and family ❤️

  • @Manifestion_kannada
    @Manifestion_kannada 11 дней назад

    Make more videos on like SQL

  • @Geethika1103
    @Geethika1103 12 дней назад

    Thanks for doing video on print function it helps a lot ✨

  • @kingsleyarisah6354
    @kingsleyarisah6354 20 дней назад

    Sounds like dense_rank()

    • @codewithvenkym
      @codewithvenkym 20 дней назад

      I explained about dense_rank() and rank() in full video, you can check and Thank you for commenting ❤️

  • @mohanreddy2039
    @mohanreddy2039 Месяц назад

    Cfbr

  • @prasanthgangula1840
    @prasanthgangula1840 Месяц назад

    Thank you... ❤

  • @madhudane
    @madhudane Месяц назад

    🤓

  • @devendrayannamananeni7899
    @devendrayannamananeni7899 Месяц назад

    ❤

  • @Manifestion_kannada
    @Manifestion_kannada Месяц назад

    Thankyou again bottom of my heart .i seen lots of videos of joins but your teaching explaining on paper how join is happening 👌👌❤❤ now i am perfect in SQL I can solve any queries

  • @Geethika1103
    @Geethika1103 Месяц назад

    Learning a lot from your videos want more for DSA and python coding

  • @Manifestion_kannada
    @Manifestion_kannada Месяц назад

    Thankyou for explaining in detail. Solve more questions on join and analytical functions it will help me in interview 😊. You hand writing are Good .

  • @AnnaStafford-s7d
    @AnnaStafford-s7d Месяц назад

    Thanks a lot, your material is so helpful!😮‍💨

  • @Geethika1103
    @Geethika1103 Месяц назад

    👏🏻👏🏻

  • @bapirajui
    @bapirajui Месяц назад

    But in that only one table available employee how we get manager table

    • @codewithvenkym
      @codewithvenkym Месяц назад

      In Employee table we have managerId right with that column we need to compare employeeId and mangerId. For that we can use Self join, where it easy the work to retrieve data or information which involves comparing records within the same table.

  • @MusicalShorts-hn1px
    @MusicalShorts-hn1px Месяц назад

    Please add table creation commands in description box....would be helpful to practice

  • @raveendraravikala269
    @raveendraravikala269 Месяц назад

    Good Venky. Good explanation

  • @Geethika1103
    @Geethika1103 Месяц назад

    Keep posting videos waiting for this video 🥹

  • @Geethika1103
    @Geethika1103 Месяц назад

    Thanks for doing videos on leetcode problems please explain more problems on leetcode

  • @yashwanthreddy8554
    @yashwanthreddy8554 Месяц назад

    Good one Venky. Way to go ❤

  • @Geethika1103
    @Geethika1103 Месяц назад

    Keep posting daily learning so many new things from your videos 😊

  • @mohanreddy2039
    @mohanreddy2039 Месяц назад

    Well explained

  • @adnaan8485
    @adnaan8485 Месяц назад

    Great explanation

  • @mayarabhavani3553
    @mayarabhavani3553 Месяц назад

    Good bro

  • @santhoshchintu8255
    @santhoshchintu8255 Месяц назад

    Great explanation Venky

  • @mutharaojubburu4895
    @mutharaojubburu4895 Месяц назад

    Good bro 👍

  • @muskelon8666
    @muskelon8666 Месяц назад

    Good 🎉

  • @mpr2801
    @mpr2801 Месяц назад

    Good explanation Venky!! Expecting many more

  • @Geethika1103
    @Geethika1103 Месяц назад

    Great explanation expecting more videos from Pl/sql also

  • @geethika7626
    @geethika7626 5 месяцев назад

    Count me in for this coding journey! Ready to learn and grow together. 💡💻 🎉🎉

  • @mayaravenky5788
    @mayaravenky5788 5 месяцев назад

    Getting ready to learn with you @codewithvenkym 🎉🎉❤❤❤🎉🎉 All the best

  • @muskelon8666
    @muskelon8666 5 месяцев назад

    All the best for future videos bro @codewithvenkym ❤❤🎉🎉

  • @mayaravenkateswararaomayar8803
    @mayaravenkateswararaomayar8803 5 месяцев назад

    Exciting for more content to come 🎉🎉🎉

  • @devjanuvlogs
    @devjanuvlogs 5 месяцев назад

    Exciting for more videos to come and waiting to learn with you @codewithvenkym🎉🎉🎉