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: 🔗 RUclips 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!
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;
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?
![MLV Prasad - LeetCode SQL [ EASY ] | 1667 | "Fix Names in a Table" |](http://i.ytimg.com/vi/vbBV4DZF5Nk/mqdefault.jpg)
![MLV Prasad - LeetCode SQL [ EASY ] | 1667 | "Fix Names in a Table" |](/img/tr.png)
![LeetCode 1661: Average Time of Process per Machine [SQL]](http://i.ytimg.com/vi/HIdABN5nZyo/mqdefault.jpg)
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:
🔗 RUclips 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!
This is the perfect explaination on youtube
Great Explanation. I was searching for the good explanation video for this sql problem. Gladd!! i found it.
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
Tq very much for your kind response naveen
the way you explained question and answer mindblowing. Keep it sir!
Thanks a ton... These appreciations means a lot
wow bro the diagram to explain self join is top notch! you're doing great!!
this question was marked easy, but i was confused about self join, your video rly explained well. thanks
Nice explanation. Thank you👍👍
Well explained.
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;
nice explanation
Really good content.
Tq very much
thank you
nice explanation mate
Glad you liked it
Thanks 😊
Welcome 😊
well explained keep going
Thank you, I will
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?