![Data Science University - MLV Prasad](/img/default-banner.jpg)
- 188
- 70 072
Data Science University - MLV Prasad
India
เข้าร่วมเมื่อ 6 ก.พ. 2023
☑️ Hi, I am MLV Prasad .
🥇 M.Sc Computer Science in Artificial Intelligence and Machine Learning | @Woolf University 2022-24
💫 I am a Deep-Learning ( CV and NLP ) Enthusiast
⭐ Data Scentist - LLM @ Turing | Ex- DS @codinginvaders , @cyient
✌️ Creating Data Science Content on TH-cam and sharing my knowledge
🤝 Ready to connect with Deep Learning Enthusiasts
📞 + 91 - 7680896860 | whatsapp | Bangalore . India
📩 mlvprasadofficial@gmail.com
🥇 M.Sc Computer Science in Artificial Intelligence and Machine Learning | @Woolf University 2022-24
💫 I am a Deep-Learning ( CV and NLP ) Enthusiast
⭐ Data Scentist - LLM @ Turing | Ex- DS @codinginvaders , @cyient
✌️ Creating Data Science Content on TH-cam and sharing my knowledge
🤝 Ready to connect with Deep Learning Enthusiasts
📞 + 91 - 7680896860 | whatsapp | Bangalore . India
📩 mlvprasadofficial@gmail.com
MLV Prasad - LeetCode SQL [ MEDIUM ] | League Statistics | " 1841 " |
MLV PRASAD - Unlocking the Power of SQL for Interviews
💫 Welcome to MLV PRASAD's TH-cam channel! :
Donate UPI : mlvhdfc@ybl or 7680896860
Donate : ko-fi.com/mlvprasadofficial
Reach out :
📞 : +91 76808 96860
📩 : mlvprasadofficial@gmail.com
LinkedIn : www.linkedin.com/in/mlvprasadofficial/
Topmate : topmate.io/mlvprasad
Kaggle : kaggle.com/mlvprasad
🎥 I am dedicated to providing you with comprehensive educational videos
where I screen record and solve LeetCode SQL questions. Join us on
this exciting journey as we explore the depths of SQL, Deep learning
(Computer Vision,NLP) AI research, Kaggle and data analytics.
🌟 About MLV PRASAD:
MLV PRASAD is an enthusiastic learner and practitioner in the fields
of deep learning, AI research, and data analytics. With a strong
passion for unlocking the potential of SQL, MLV PRASAD aims to share
valuable insights, techniques, and real-world examples to help you excel
in your coding interviews and beyond.
📚 LeetCode SQL Solutions Repository:
For quick access to the solutions demonstrated in our videos, visit our
GitHub repository:
github.com/MlvPrasadOfficial/LeetCode_SQL_Solutions_MLV_Prasad.
You'll find a comprehensive collection of LeetCode SQL solutions that
you can refer to for practice and further exploration.
🔗 Connect with MLV PRASAD:
Looking to connect and stay updated with the latest developments in the
industry?
Connect with MLV PRASAD on LinkedIn:
www.linkedin.com/in/mlvprasadofficial/.
Feel free to reach out for discussions, collaborations, or any queries you may have.
Have a specific question or need personalized guidance? Reach out to MLV
PRASAD directly on WhatsApp at +91 7680896860 (Please note that
response times may vary due to high demand.)
🎯 The Power of Learning SQL and LeetCode for Interviews:
Mastering SQL and LeetCode is crucial for excelling in technical interviews. By
understanding the intricacies of SQL query writing, optimization, and
data manipulation, you'll enhance your problem-solving skills and gain a
competitive edge. Our videos will guide you through various LeetCode
SQL questions, providing step-by-step explanations, best practices, and
effective strategies to tackle interview challenges.
💡 Exploring Kaggle and Real-World Applications:
At MLV PRASAD's channel, we recognize the importance of practical
experience. We embrace the Kaggle platform to showcase real-world use
cases, competitions, and data analysis projects. Explore fascinating
datasets, work on industry-relevant problems, and learn how SQL fits
into the bigger picture of data science.
🎓 Academic Pursuit:
MLV PRASAD is currently pursuing an M.Sc. in Computer Science specializing
in AI and ML from Woolf University (2022-2024). This academic background
provides a solid foundation for delivering high-quality educational
content and staying up to date with the latest advancements in the
field.
✨ Passion for Empowering Learners:
MLV PRASAD's passion lies in empowering individuals to achieve their goals through knowledge
sharing and mentorship. The channel is dedicated to fostering a
supportive learning environment where viewers can thrive, ask questions,
and engage in discussions. Together, let's enhance our skills and
unlock new opportunities in the exciting world of SQL, deep learning, AI
research, and data analytics.
Join MLV PRASAD's TH-cam channel :
today and embark on an enlightening journey of SQL mastery! Don't forget
to subscribe, like, and share the videos to help us reach a wider
audience. Let's code, learn, and grow together! 🚀
💫 Welcome to MLV PRASAD's TH-cam channel! :
Donate UPI : mlvhdfc@ybl or 7680896860
Donate : ko-fi.com/mlvprasadofficial
Reach out :
📞 : +91 76808 96860
📩 : mlvprasadofficial@gmail.com
LinkedIn : www.linkedin.com/in/mlvprasadofficial/
Topmate : topmate.io/mlvprasad
Kaggle : kaggle.com/mlvprasad
🎥 I am dedicated to providing you with comprehensive educational videos
where I screen record and solve LeetCode SQL questions. Join us on
this exciting journey as we explore the depths of SQL, Deep learning
(Computer Vision,NLP) AI research, Kaggle and data analytics.
🌟 About MLV PRASAD:
MLV PRASAD is an enthusiastic learner and practitioner in the fields
of deep learning, AI research, and data analytics. With a strong
passion for unlocking the potential of SQL, MLV PRASAD aims to share
valuable insights, techniques, and real-world examples to help you excel
in your coding interviews and beyond.
📚 LeetCode SQL Solutions Repository:
For quick access to the solutions demonstrated in our videos, visit our
GitHub repository:
github.com/MlvPrasadOfficial/LeetCode_SQL_Solutions_MLV_Prasad.
You'll find a comprehensive collection of LeetCode SQL solutions that
you can refer to for practice and further exploration.
🔗 Connect with MLV PRASAD:
Looking to connect and stay updated with the latest developments in the
industry?
Connect with MLV PRASAD on LinkedIn:
www.linkedin.com/in/mlvprasadofficial/.
Feel free to reach out for discussions, collaborations, or any queries you may have.
Have a specific question or need personalized guidance? Reach out to MLV
PRASAD directly on WhatsApp at +91 7680896860 (Please note that
response times may vary due to high demand.)
🎯 The Power of Learning SQL and LeetCode for Interviews:
Mastering SQL and LeetCode is crucial for excelling in technical interviews. By
understanding the intricacies of SQL query writing, optimization, and
data manipulation, you'll enhance your problem-solving skills and gain a
competitive edge. Our videos will guide you through various LeetCode
SQL questions, providing step-by-step explanations, best practices, and
effective strategies to tackle interview challenges.
💡 Exploring Kaggle and Real-World Applications:
At MLV PRASAD's channel, we recognize the importance of practical
experience. We embrace the Kaggle platform to showcase real-world use
cases, competitions, and data analysis projects. Explore fascinating
datasets, work on industry-relevant problems, and learn how SQL fits
into the bigger picture of data science.
🎓 Academic Pursuit:
MLV PRASAD is currently pursuing an M.Sc. in Computer Science specializing
in AI and ML from Woolf University (2022-2024). This academic background
provides a solid foundation for delivering high-quality educational
content and staying up to date with the latest advancements in the
field.
✨ Passion for Empowering Learners:
MLV PRASAD's passion lies in empowering individuals to achieve their goals through knowledge
sharing and mentorship. The channel is dedicated to fostering a
supportive learning environment where viewers can thrive, ask questions,
and engage in discussions. Together, let's enhance our skills and
unlock new opportunities in the exciting world of SQL, deep learning, AI
research, and data analytics.
Join MLV PRASAD's TH-cam channel :
today and embark on an enlightening journey of SQL mastery! Don't forget
to subscribe, like, and share the videos to help us reach a wider
audience. Let's code, learn, and grow together! 🚀
มุมมอง: 428
วีดีโอ
MLV Prasad - LeetCode SQL [ MEDIUM ] | Active Users | " 1454 " |
มุมมอง 2329 หลายเดือนก่อน
MLV PRASAD - Unlocking the Power of SQL for Interviews 💫 Welcome to MLV PRASAD's TH-cam channel! : Donate UPI : mlvhdfc@ybl or 7680896860 Donate : ko-fi.com/mlvprasadofficial Reach out : 📞 : 91 76808 96860 📩 : mlvprasadofficial@gmail.com LinkedIn : www.linkedin.com/in/mlvprasadofficial/ Topmate : topmate.io/mlvprasad Kaggle : kaggle.com/mlvprasad 🎥 I am dedicated to providing you with comprehen...
MLV Prasad - LeetCode SQL [ MEDIUM ] | Number of Trusted Contacts of a Customer | " 1364 " |
มุมมอง 1709 หลายเดือนก่อน
MLV PRASAD - Unlocking the Power of SQL for Interviews 💫 Welcome to MLV PRASAD's TH-cam channel! : Donate UPI : mlvhdfc@ybl or 7680896860 Donate : ko-fi.com/mlvprasadofficial Reach out : 📞 : 91 76808 96860 📩 : mlvprasadofficial@gmail.com LinkedIn : www.linkedin.com/in/mlvprasadofficial/ Topmate : topmate.io/mlvprasad Kaggle : kaggle.com/mlvprasad 🎥 I am dedicated to providing you with comprehen...
MLV Prasad - LeetCode SQL [ MEDIUM ] | | "1321 " | Restaurant Growth
มุมมอง 58810 หลายเดือนก่อน
MLV PRASAD - Unlocking the Power of SQL for Interviews 💫 Welcome to MLV PRASAD's TH-cam channel! : Donate UPI : mlvhdfc@ybl or 7680896860 Donate : ko-fi.com/mlvprasadofficial Reach out : 📞 : 91 76808 96860 📩 : mlvprasadofficial@gmail.com LinkedIn : www.linkedin.com/in/mlvprasadofficial/ Topmate : topmate.io/mlvprasad Kaggle : kaggle.com/mlvprasad 🎥 I am dedicated to providing you with comprehen...
MLV Prasad - LeetCode SQL [ MEDIUM ] | | " 1264" | Page Recommendations
มุมมอง 11610 หลายเดือนก่อน
MLV PRASAD - Unlocking the Power of SQL for Interviews 💫 Welcome to MLV PRASAD's TH-cam channel! : Donate UPI : mlvhdfc@ybl or 7680896860 Donate : ko-fi.com/mlvprasadofficial Reach out : 📞 : 91 76808 96860 📩 : mlvprasadofficial@gmail.com LinkedIn : www.linkedin.com/in/mlvprasadofficial/ Topmate : topmate.io/mlvprasad Kaggle : kaggle.com/mlvprasad 🎥 I am dedicated to providing you with comprehen...
MLV Prasad - LeetCode SQL [ MEDIUM ] | | "1205 " | Monthly Transactions II
มุมมอง 18210 หลายเดือนก่อน
MLV PRASAD - Unlocking the Power of SQL for Interviews 💫 Welcome to MLV PRASAD's TH-cam channel! : Donate UPI : mlvhdfc@ybl or 7680896860 Donate : ko-fi.com/mlvprasadofficial Reach out : 📞 : 91 76808 96860 📩 : mlvprasadofficial@gmail.com LinkedIn : www.linkedin.com/in/mlvprasadofficial/ Topmate : topmate.io/mlvprasad Kaggle : kaggle.com/mlvprasad 🎥 I am dedicated to providing you with comprehen...
MLV Prasad - LeetCode SQL [ MEDIUM ] | 1164 | " Product Price at a Given DateI " |
มุมมอง 46910 หลายเดือนก่อน
MLV PRASAD - Unlocking the Power of SQL for Interviews 💫 Welcome to MLV PRASAD's TH-cam channel! : Donate UPI : mlvhdfc@ybl or 7680896860 Donate : ko-fi.com/mlvprasadofficial Reach out : 📞 : 91 76808 96860 📩 : mlvprasadofficial@gmail.com LinkedIn : www.linkedin.com/in/mlvprasadofficial/ Topmate : topmate.io/mlvprasad Kaggle : kaggle.com/mlvprasad 🎥 I am dedicated to providing you with comprehen...
MLV Prasad - LeetCode SQL [ MEDIUM ] | 2853 | " Highest Salaries Difference " |
มุมมอง 14210 หลายเดือนก่อน
MLV PRASAD - Unlocking the Power of SQL for Interviews 💫 Welcome to MLV PRASAD's TH-cam channel! : Donate UPI : mlvhdfc@ybl or 7680896860 Donate : ko-fi.com/mlvprasadofficial Reach out : 📞 : 91 76808 96860 📩 : mlvprasadofficial@gmail.com LinkedIn : www.linkedin.com/in/mlvprasadofficial/ Topmate : topmate.io/mlvprasad Kaggle : kaggle.com/mlvprasad 🎥 I am dedicated to providing you with comprehen...
MLV Prasad - LeetCode SQL [ MEDIUM ] | 2837 | " Total Traveled Distance " |
มุมมอง 10510 หลายเดือนก่อน
MLV PRASAD - Unlocking the Power of SQL for Interviews 💫 Welcome to MLV PRASAD's TH-cam channel! : Donate UPI : mlvhdfc@ybl or 7680896860 Donate : ko-fi.com/mlvprasadofficial Reach out : 📞 : 91 76808 96860 📩 : mlvprasadofficial@gmail.com LinkedIn : www.linkedin.com/in/mlvprasadofficial/ Topmate : topmate.io/mlvprasad Kaggle : kaggle.com/mlvprasad 🎥 I am dedicated to providing you with comprehen...
MLV Prasad - LeetCode SQL [ MEDIUM ] | 1132 | " Reported Posts II " |
มุมมอง 14910 หลายเดือนก่อน
MLV PRASAD - Unlocking the Power of SQL for Interviews 💫 Welcome to MLV PRASAD's TH-cam channel! : Donate UPI : mlvhdfc@ybl or 7680896860 Donate : ko-fi.com/mlvprasadofficial Reach out : 📞 : 91 76808 96860 📩 : mlvprasadofficial@gmail.com LinkedIn : www.linkedin.com/in/mlvprasadofficial/ Topmate : topmate.io/mlvprasad Kaggle : kaggle.com/mlvprasad 🎥 I am dedicated to providing you with comprehen...
MLV Prasad - LeetCode SQL [ MEDIUM ] | 1107 | " New Users Daily Count " |
มุมมอง 9910 หลายเดือนก่อน
MLV PRASAD - Unlocking the Power of SQL for Interviews 💫 Welcome to MLV PRASAD's TH-cam channel! : Donate UPI : mlvhdfc@ybl or 7680896860 Donate : ko-fi.com/mlvprasadofficial Reach out : 📞 : 91 76808 96860 📩 : mlvprasadofficial@gmail.com LinkedIn : www.linkedin.com/in/mlvprasadofficial/ Topmate : topmate.io/mlvprasad Kaggle : kaggle.com/mlvprasad 🎥 I am dedicated to providing you with comprehen...
MLV Prasad - LeetCode SQL [ MEDIUM ] | 1045 | " Customers Who Bought All Products " |
มุมมอง 24910 หลายเดือนก่อน
MLV PRASAD - Unlocking the Power of SQL for Interviews 💫 Welcome to MLV PRASAD's TH-cam channel! : Donate UPI : mlvhdfc@ybl or 7680896860 Donate : ko-fi.com/mlvprasadofficial Reach out : 📞 : 91 76808 96860 📩 : mlvprasadofficial@gmail.com LinkedIn : www.linkedin.com/in/mlvprasadofficial/ Topmate : topmate.io/mlvprasad Kaggle : kaggle.com/mlvprasad 🎥 I am dedicated to providing you with comprehen...
MLV Prasad - LeetCode SQL [ MEDIUM ] | 0614 | " Second Degree Follower " |
มุมมอง 11410 หลายเดือนก่อน
MLV PRASAD - Unlocking the Power of SQL for Interviews 💫 Welcome to MLV PRASAD's TH-cam channel! : Donate UPI : mlvhdfc@ybl or 7680896860 Donate : ko-fi.com/mlvprasadofficial Reach out : 📞 : 91 76808 96860 📩 : mlvprasadofficial@gmail.com LinkedIn : www.linkedin.com/in/mlvprasadofficial/ Topmate : topmate.io/mlvprasad Kaggle : kaggle.com/mlvprasad 🎥 I am dedicated to providing you with comprehen...
MLV Prasad - LeetCode SQL [ MEDIUM ] | 0608 | " Tree Node " |
มุมมอง 6810 หลายเดือนก่อน
MLV PRASAD - Unlocking the Power of SQL for Interviews 💫 Welcome to MLV PRASAD's TH-cam channel! : Donate UPI : mlvhdfc@ybl or 7680896860 Donate : ko-fi.com/mlvprasadofficial Reach out : 📞 : 91 76808 96860 📩 : mlvprasadofficial@gmail.com LinkedIn : www.linkedin.com/in/mlvprasadofficial/ Topmate : topmate.io/mlvprasad Kaggle : kaggle.com/mlvprasad 🎥 I am dedicated to providing you with comprehen...
MLV Prasad - LeetCode SQL [ MEDIUM ] | 0585 | " Investments in 2016 " |
มุมมอง 27310 หลายเดือนก่อน
MLV PRASAD - Unlocking the Power of SQL for Interviews 💫 Welcome to MLV PRASAD's TH-cam channel! : Donate UPI : mlvhdfc@ybl or 7680896860 Donate : ko-fi.com/mlvprasadofficial Reach out : 📞 : 91 76808 96860 📩 : mlvprasadofficial@gmail.com LinkedIn : www.linkedin.com/in/mlvprasadofficial/ Topmate : topmate.io/mlvprasad Kaggle : kaggle.com/mlvprasad 🎥 I am dedicated to providing you with comprehen...
MLV Prasad - LeetCode SQL [ MEDIUM ] | 0602 | "Friend Requests II: Who Has the Most Friends " |
มุมมอง 22110 หลายเดือนก่อน
MLV Prasad - LeetCode SQL [ MEDIUM ] | 0602 | "Friend Requests II: Who Has the Most Friends " |
MLV Prasad - LeetCode SQL [ MEDIUM] | 2738 | "COUNT OCCURENCE IN TEXTS" |
มุมมอง 214ปีที่แล้ว
MLV Prasad - LeetCode SQL [ MEDIUM] | 2738 | "COUNT OCCURENCE IN TEXTS" |
MLV Prasad - LeetCode SQL [ MEDIUM] | 2688 | "FIND ACTIVE USERS" |
มุมมอง 149ปีที่แล้ว
MLV Prasad - LeetCode SQL [ MEDIUM] | 2688 | "FIND ACTIVE USERS" |
MLV Prasad - LeetCode SQL [ MEDIUM] | 2388 | "Change Null Values in a Table to the Previous Value" |
มุมมอง 239ปีที่แล้ว
MLV Prasad - LeetCode SQL [ MEDIUM] | 2388 | "Change Null Values in a Table to the Previous Value" |
MLV Prasad - LeetCode SQL [ MEDIUM] | 2686 | "IMMEDIATE FOOD DELIVERY" |
มุมมอง 149ปีที่แล้ว
MLV Prasad - LeetCode SQL [ MEDIUM] | 2686 | "IMMEDIATE FOOD DELIVERY" |
MLV Prasad - LeetCode SQL [ MEDIUM] | 2372 | "Calculate the Influence of Each Salesperson" |
มุมมอง 69ปีที่แล้ว
MLV Prasad - LeetCode SQL [ MEDIUM] | 2372 | "Calculate the Influence of Each Salesperson" |
MLV Prasad - LeetCode SQL [ MEDIUM] | 2346 | "Compute the Rank as a Percentage" |
มุมมอง 87ปีที่แล้ว
MLV Prasad - LeetCode SQL [ MEDIUM] | 2346 | "Compute the Rank as a Percentage" |
MLV Prasad - LeetCode SQL [ MEDIUM] |2314| "The First Day of Maximum Recorded Degree in Each City" |
มุมมอง 89ปีที่แล้ว
MLV Prasad - LeetCode SQL [ MEDIUM] |2314| "The First Day of Maximum Recorded Degree in Each City" |
MLV Prasad - LeetCode SQL [ MEDIUM] | 2324 | "Product Sales Analysis IV" |
มุมมอง 92ปีที่แล้ว
MLV Prasad - LeetCode SQL [ MEDIUM] | 2324 | "Product Sales Analysis IV" |
MLV Prasad - LeetCode SQL [ MEDIUM] | 2308 | "Arrange Table by Gender" |
มุมมอง 85ปีที่แล้ว
MLV Prasad - LeetCode SQL [ MEDIUM] | 2308 | "Arrange Table by Gender" |
MLV Prasad - LeetCode SQL [ MEDIUM] | 2298 | "Tasks Count in the Weekend" |
มุมมอง 98ปีที่แล้ว
MLV Prasad - LeetCode SQL [ MEDIUM] | 2298 | "Tasks Count in the Weekend" |
MLV Prasad - LeetCode SQL [ MEDIUM] | 2292 | "Products With Three or More Order in 2 Consecutive " |
มุมมอง 185ปีที่แล้ว
MLV Prasad - LeetCode SQL [ MEDIUM] | 2292 | "Products With Three or More Order in 2 Consecutive " |
MLV Prasad - LeetCode SQL [ MEDIUM] | 2238 | "Number of Times a Driver Was a Passenger" |
มุมมอง 81ปีที่แล้ว
MLV Prasad - LeetCode SQL [ MEDIUM] | 2238 | "Number of Times a Driver Was a Passenger" |
MLV Prasad - LeetCode SQL [ MEDIUM] | 2228 | "Users With Two Purchases Within Seven Days" |
มุมมอง 83ปีที่แล้ว
MLV Prasad - LeetCode SQL [ MEDIUM] | 2228 | "Users With Two Purchases Within Seven Days" |
MLV Prasad - LeetCode SQL [ MEDIUM] | 2175 | "The Change in Global Rankings" |
มุมมอง 83ปีที่แล้ว
MLV Prasad - LeetCode SQL [ MEDIUM] | 2175 | "The Change in Global Rankings" |
Thanks for making such a wonderful video
Thanks for encouragement..
y cant we use groupby email here and can take min of id
For those getting an error on this one , since rank is a keyword, use it in single quotes SELECT score , dense_rank() OVER (ORDER BY score DESC) AS 'rank' FROM Scores
is this leetcode playlist useful for data engineering?
Sql is required for data engineer along with pyspark
@@ai.mlvprasad 👍
@@ai.mlvprasad please make a playlist for the pyspark also
@@SandipTiwari-lr8hf +1
bro are you tamil
Vizag /telugu
bhai sari premium problem kyo kra rahe ho, sab ke pas leetcode ka premium nhi hai
Using dense rank instead of rank my solution was accepted
Excellent Logic! keep up the good work .. waiting for more videos!
Nice explanation sir🎉
Thanks a lot for this video! Great explanation.
Thank you sir!
Welcome Anubhav rathi
Code failed with following error "BIGINT UNSIGNED value is out of range in '(`test`.`logs`.`id` - `row_number() OVER (PARTITION BY ``logs``.num ORDER BY ``logs``.id ) `)' " The code I used was ` with cte as ( select id, num , id - row_number() over(partition by num order by id) row_diff from logs ) select distinct num ConsecutiveNums from cte group by num, row_diff having count(*) >= 3 `
Thanks for this great explanation!
Thank you Manisha..
Great Explanation. I was searching for the good explanation video for this sql problem. Gladd!! i found it.
Thank You for SQL SERVER Answer
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;
Hi Prasad, Im getting this error as "Incorrect parameter count in the call to native function 'DATEDIFF'" I gave the exact code like you gave select b.id as id from Weather a inner join Weather b on DATEDIFF(Day, a.recordDate, b.recordDate) = 1 and a.temperature < b.temperature
DATEDIFF(b.recordDate, a.recordDate) = 1
very helpful video .. i skip this question
select player_id, device_id from Activity where event_date in (select min(event_date) as event_date group by player_id from Activity) is the above query achive the same results i cannot test it bcz the problem is for premium subscribers. pls tell if possible
hi MLV Prasad kaisa hai bhai ?
this ques is should be marked very easy !!
it was helpful
NIce work❤
Thank you! 😊
Please explain more of why you are doing particular thing i started from basics and its really hard to understood
When I run the solution it shows "accepted" with 0.33 as output but when I submit I get wrong answer displayed. WHy like that?Sir please help
Thank you for your video
Good work and clear explanation! Thank you Prasad
So nice of you
Would be better for freshers if more explanation is shown before doing each step
Best Explanation. Thanks
Thank you very much lokesh
I can’t see these questions now on leet code . Please help
nice explanation
Thanks and welcome
with cte as ( select seat_id, free, lead(free, 1) over( order by seat_id ) as next lag(free, 1) over( order by seat_id ) as prev from cinema ) select seat_id from cte where ( free = next or free = prev) and free = 1
hi MLV Prasad can you please explain this below hierarchy query (or) make a video on it with your own style......... I was unable to crack this need your support thanks in advance......❤❤✌✌ CREATE TABLE company ( employee varchar(10) primary key, manager varchar(10) ); INSERT INTO company values ('Elon', null); INSERT INTO company values ('Ira', 'Elon'); INSERT INTO company values ('Bret', 'Elon'); INSERT INTO company values ('Earl', 'Elon'); INSERT INTO company values ('James', 'Ira'); INSERT INTO company values ('Drew', 'Ira'); INSERT INTO company values ('Mark', 'Bret'); INSERT INTO company values ('Phil', 'Mark'); INSERT INTO company values ('Jon', 'Mark'); INSERT INTO company values ('Omid', 'Earl'); SELECT * FROM company; /* Given graph shows the hierarchy of employees in a company. Write an SQL query to split the hierarchy and show the employees corresponding to their team.*/ WITH RECURSIVE cte_teams AS ( SELECT mng.employee, CONCAT('Team', ROW_NUMBER() OVER (ORDER BY mng.employee)) AS teams FROM company root JOIN company mng ON root.employee = mng.manager WHERE root.manager IS NULL ), cte AS ( SELECT c.employee, c.manager, t.teams FROM company c CROSS JOIN cte_teams t WHERE c.manager IS NULL UNION SELECT c.employee, c.manager, COALESCE(t.teams, cte.teams) AS teams FROM company c JOIN cte ON cte.employee = c.manager LEFT JOIN cte_teams t ON t.employee = c.employee ) SELECT teams, GROUP_CONCAT(employee, ', ') AS members FROM cte GROUP BY teams ORDER BY teams;
how about filtering the salary using desc use distinct select the position 2
[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]An expression of non-boolean type specified in a context where a condition is expected, near ','. (4145) (SQLExecDirectW) getting this following error near where clause can you help.. select * from activity a inner join activity b on dateadd(day,1,a.event_date) = b.event_date and a.player_id = b.player_id where (a.event_date,a.player_id) in (select min(event_date),player_id from activity group by player_id) this is my partial query
You may have to mentioned from where you are taking ex: (p.firstName, p.lastName, a.city, a.state) because sql doesn’t know what to take from where. Its always a good practice to put table name first. In this scenario it was acceptable if not mentioned
If it is a duplicate it is mandatory to mention alias table name, for unique column name, it is optional
@@ai.mlvprasad thank you
in the case stmt why did you use sum and not count, what is affected by using count/sum in that stmt?
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
i am not able to understand isnull functionality over here
nice explanation prasad
DELETE p1.* FROM Person AS p1 INNER JOIN Person AS p2 WHERE p1.email = p2.email AND p1.id > p2.id
very helpful playlists, thanks!
Tq very much ratika
Hi Prasad , from GitHub not able to download or open the Query , can you pls check once . Thanks for your Explanations and help
How r u thinking..which should we use and which logic should use? Does all comes under practice?
select r.contest_id , Round(((count( r.user_id))/ (SELECT count(*) FROM users)) *100, 2) as percentage from Users u Left Join Register r on u.user_id = r.user_id group by r.contest_id order by percentage desc, contest_id asc; sir i have written like this. getting error in case 2, getting null values with answer...
Hi Prasad a small correction in the final SQL script you have provided. The below code will work correctly SELECT * FROM person_7 WHERE id IN ( SELECT MIN(id) FROM person_7 GROUP BY email );
🚨Doubt : can we solve it using row_number: code : WITH ct AS ( SELECT seat_id, free, ROW_NUMBER() OVER (PARTITION BY seat_id) - free AS rn FROM Cinema ) SELECT ct.seat_id FROM ct GROUP BY ct.seat_id, ct.rn HAVING COUNT(*) > 1 order by seat_id;
Great explanation :) How many SQLquestions u think we need to practice ?
150
well explained
Tq very much…..
@@ai.mlvprasad welcome MLVP
Nice explanation. Thank you👍👍