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: 🔗 TH-cam 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!
Using ur solution only 15 test cases passed out 17 Now they are asking us to handle null avg price May be they updated test cases Thanks you for sharing knowledge I solved it
![MLV Prasad - LeetCode SQL [ EASY ] | 1280 | "Students and Examinations" |](http://i.ytimg.com/vi/hFCytQOM8HA/mqdefault.jpg)
![MLV Prasad - LeetCode SQL [ EASY ] | 1280 | "Students and Examinations" |](/img/tr.png)
![MLV Prasad - LeetCode SQL [ MEDIUM ] | 0585 | " Investments in 2016 " |](http://i.ytimg.com/vi/c79KyQnUG68/mqdefault.jpg)
![MLV Prasad - LeetCode SQL [ MEDIUM ] | Number of Trusted Contacts of a Customer | " 1364 " |](/img/n.gif)
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:
🔗 TH-cam 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 bro keep rocking
Thank you so much Lokesh 💫
Using ur solution only 15 test cases passed out 17
Now they are asking us to handle null avg price
May be they updated test cases
Thanks you for sharing knowledge
I solved it
How
@@DineshKumar-cs4gk let me know if you are also facing same issue?
Just now fixed using coalesce to handle null
@@DineshKumar-cs4gk I also did the same you did👍🏻