MLV Prasad - LeetCode SQL [ EASY ] | 1661 | "Average Time of Process per Machine" |

[@ai.mlvprasad]

Hi, this is MLV Prasad. (Mentor - Data Science & Analytics) If you are preparing for the Data scientist or Data analyst roles, Be sure to check out incredible resources, which will undoubtedly help you excel in your coding journey: 🔗 KZbin Channel Playlists: bit.ly/mlvprasad_playlist 🔗 GitHub Repository: bit.ly/mlvprasad_github_leetcode Want to have any personal guidance, connect with me via : 🔗 Linkedin : bit.ly/mlvprasad_linkedin Make sure to subscribe to My channel, explore the GitHub repository for additional resources and to stay updated on the latest coding techniques and tips. Happy coding and learning!

[@riitviksharma5932]

This is the perfect explaination on youtube

[@naveenvjdandhrudu5141]

I really like your content and the way of explanation by showing schematic way using notepad plz keep it up bro.....my support to u always

[@ai.mlvprasad]

Tq very much for your kind response naveen

[@manisha4130]

Great Explanation. I was searching for the good explanation video for this sql problem. Gladd!! i found it.

[@gradientO]

wow bro the diagram to explain self join is top notch! you're doing great!!

[@manish6801]

the way you explained question and answer mindblowing. Keep it sir!

[@ai.mlvprasad]

Thanks a ton... These appreciations means a lot

[@morishbhayani2195]

Nice explanation. Thank you👍👍

[@aamengz3406]

this question was marked easy, but i was confused about self join, your video rly explained well. thanks

[@arnobdas6365]

Really good content.

[@ai.mlvprasad]

Tq very much

[@deepikaverma6820]

Well explained.

[@satyamgupta4808]

nice explanation

[@judgebot7353]

nice explanation mate

[@ai.mlvprasad]

Glad you liked it

[@Shardul_D]

Nice! i have further optimised this and found out that this can be done without using subquery SELECT a.machine_id, ROUND(AVG(b.timestamp-a.timestamp),3) as processing_time from Activity a join Activity b on a.machine_id= b.machine_id and a.process_id = b.process_id and a.timestamp < b.timestamp Group by a.machine_id;

[@__abhay.__]

sir one doubt if we self join as you said that start and end will be combine so how the result will automatically gives the difference of the timestamp of a process? is by joining start and end column it automatically do difference?

[@nikhilpandey4118]

well explained keep going

[@ai.mlvprasad]

Thank you, I will

[@mmp9371]

thank you

[@SuyashTalks]

Thanks 😊

[@ai.mlvprasad]

Welcome 😊