ADVANCED JOIN QUESTION | CALCULATE working percentage of a taxi company | Leetcode hard question

DML Script: datasculptor.b...
Question credits: ‪@rajkumarpanigrahi2013‬
Feedback: forms.gle/NQuC...
The Data Sculptor KZbin channel is a dedicated platform that explores the art and science of working with data. This channel caters to a diverse audience, including data enthusiasts, analysts, scientists, and anyone interested in harnessing the power of data for insightful and creative purposes.
The channel covers a wide range of topics related to data manipulation, analysis, visualization, and interpretation. The term "Data Sculptor" emphasizes the creative aspect of working with data, suggesting that it's not just about raw numbers but also about crafting meaningful stories and insights from the information available.
Viewers can expect a variety of content, including tutorials on popular data analysis tools and programming languages, discussions on emerging trends in the data field, case studies showcasing innovative data applications, and tips for effective data communication. The Data Sculptor aims to demystify complex concepts, making data-related skills accessible to both beginners and experienced professionals.
Whether you're a student looking to enter the field of data science, a business professional seeking to enhance your analytical skills, or simply someone curious about the world of data, the Data Sculptor KZbin channel strives to provide engaging and informative content to help you navigate the exciting realm of data exploration and analysis.
Playlists:
SQL Interview Questions: • SQL Interview questions
Recursive CTE: • Recursive CTE
Power BI: • Power BI and DAX
Data Modeling: • Data Modelling
Generative AIs: • Generative AIs
Excel: • Excel
Follow me
Linkedin: / data-sculptor-93a00b2a8
Instagram: / datasculptor2895
Quora: datasculptorss...
BuyMeACoffee: buymeacoffee.c...

[@rajkumarpanigrahi2013]

Thanks brother 👍 for helping me

[@FromPlanetZX]

Hi, Please check the below scenario, as i'm getting different answer from my approach. For Ride = 10, it was requested_at 2020-03-04 and driver = 7 joined at 2020-03-08. Meaning only 3 drivers were available for ride_id 10 namely 10, 8, 5. Below is my approach. with RideCNT as ( Select CONVERT(varchar(6), R.requested_at, 112) as [YearMonth] , COUNT(R.ride_id) as RideReqCNT , COUNT(AR.ride_id) as RideAcceptCNT from Rides R LEFT JOIN AcceptedRides AR ON R.ride_id = AR.ride_id GROUP BY CONVERT(varchar(6), R.requested_at, 112) -- ORDER BY 1 ) , DriverCNT as ( Select CONVERT(nvarchar(6), R.requested_at, 112) As YearMonth , COUNT(DISTINCT R.ride_id) as RideReqCNT , COUNT(distinct driver_id) as DriverAvailCNT from Rides R LEFT JOIN Drivers D ON R.requested_at >= D.join_date GROUP BY CONVERT(nvarchar(6), requested_at, 112) ) Select A.YearMonth, A.RideReqCNT, B.DriverAvailCNT, A.RideAcceptCNT , CASE WHEN DriverAvailCNT = 0 THEN 0 ELSE RideAcceptCNT * 100.0 / DriverAvailCNT END AS working_percentage from RideCNT A INNER JOIN DriverCNT B ON A.YearMonth = B.YearMonth;