Average Time of Process per Machine | Leetcode 1661 | Crack SQL Interviews in 50 Qs

Want to crack SQL interviews? Check out our latest video!!!
A 50-questions SQL study plan to ace any interview.
This tutorial will walk you through the solution in easy steps. This is an easy-level question from Leetcode.
Consistency is what transforms average into excellence.
So be consistent & keep Coding💻!!
SQL Study Plan : leetcode.com/studyplan/top-sq...
SQL Playlist: • Crack SQL Interview in...
Timecodes
0:00 - Introduction
0:10 - Question Explanation
2:15 - Understanding Concept with the help of Example
4:32 - Writing SQL Query (Method - 1)
7:16 - Explanation of the Query (Method - 1)
8:34 - Outro
Connect With Me -
Instagram: / createwithc. .
Email: [e-mail]
#coding
#leetcode
#mysql
#sql
#interview
#sqlinterview
#sqlinterviewquestionsandanswers
#sql_server
#article
#learnwithchirag
#average
#time
#machine
#easy

[@learnwithchirag]

Hey there! 👋 For more interesting content, tutorials, and updates, Feel free to connect with me on Instagram Handles :- @createwithchirag - instagram.com/createwithchirag/ @learn.with.chirag - instagram.com/learn.with.chirag/ LinkedIn: www.linkedin.com/in/chirag-sehgal-9200111b8/ Let's stay connected and keep the creativity flowing! 💡

[@GuruVamshi]

Excellent Bhai 😍

[@Still_standing418]

Another Problem made easy, thanks.

[@learnwithchirag]

Glad to help❤️

[@akhilpratapsingh3223]

Nice explanation bhaiya

[@learnwithchirag]

Thanks brother ! Keep Learning :)

[@cricmizz2526]

thanks bhayia

[@learnwithchirag]

Always welcome. Keep watching 🎉

[@nimbu_03]

Nice Explaination!

[@learnwithchirag]

Thanks! Keep Watching 🎉

[@jeevananuragi6500]

sir i want ot be data analyst..guide me plz.. what topics what project where to find job where to practice and which topic problems which oyutube channel or source is good

[@learnwithchirag]

For becoming a good Data Analyst , these are the steps you need to follow- 1) Understand Business - how they work , how data is important for them , which type of data can increase their revenue. 2) Learn Relevant Skills & tools - excell , SQL , Power BI or tabelue , also research for tools which are in demand these days and learn them too. 3) Profile Building - Make real time projects , take data from websites like kaggle , also take data from some real business and try to implement them , make dashboard ....make advance projects , see the people already in this industry , what projects are they making.... make ATS Friendly resume , do internship or freelancing projects 4) Build Network & Apply for Job - Use Platforms like Linked In , Twitter ...showcase your skills their and tag recruiters from your dream company....if your work will be good they will definitely reach back to you. At last apply for 100s of jobs , you will get reply from atleast 4-5 of them.

[@vanshika7243]

please explain how ON is working here!!!!!

[@learnwithchirag]

The "ON" clause in this query specifies the conditions for joining records from the Activity table with itself (a1 and a2 instances) based on matching process_id and machine_id, and ensuring that the activities are ordered correctly in terms of time. If its still not clear , I will request you to dry run the query once. And no need to worry , you will get the clarity of concept when you will complete the playlist. Start from video 1 and go till video 50. You will be a champ in SQL.💯

[@AmandeepSingh-gv8gg]

but sir why group by

[@yashrodge3050]

Because we have duplicate machine id

[@Krishnaeagle-ex4zj]

Hi @learnwithchirag how did you able to run the code to get output int grid format at 5:30

[@DollyDhote-wi9cs]

why we created a1 and a2

[@learnwithchirag]

It's called self join. We created two instances of a single table in order to return the required result. Please do watch all the videos you will get this concept more clearly! Keep Learning 💯