21. Immediate Food Delivery II | SQL Interview Questions and Answers

Immediate Food Delivery II
Sql interview question and answer
Connect with me
Instagram : / i._am._arfin
LinkedIn : / arfin-parween
Twitter : / startpracticing
Email : [e-mail]
Github : github.com/arf...
Check this Repository: github.com/arf...
Leetcode Link: leetcode.com/p...
Solution Link: github.com/arf...
Checkout Full Playlist: • Leetcode TOP SQL 50
Timeline
THANK YOU FOR WATCHING
_________________________________________
Please like share comments and subscribe
___________________________________________
To watch more tutorial, press the below link
Playlist of Data Structure and Algorithm
• Data Structure and Alg...
Playlist of operation research
• Operation Research In ...
Playlist of Transportation Problem
• Transportation problem...
Related Tags
Immediate Food Delivery II
Immediate Food Delivery II leetcode
Immediate Food Delivery leetcode
sql interview question and answer
sql interview questions and answers for experienced
sql interview questions and answers for freshers
sql query interview questions and answers
data structure and algorithm
data structures interview questions and answers
data structures and algorithms in java full course
leetcode
leetcode problem
leetcode sql
leetcode solution
data structure playlist full course
Arfin
Arfin Parween
Start practicing
Hashtag
#sql #leetcode #leetcodesql #leetcodesolution #sqlforbeginners #sqlinterviewquestions
#arfin #startpracticing #arfinparween
#bca #computerscience #interview #dsa #sqlwitharfin

[@sehajdeepsingh7427]

I think a new testCase is added in this ques, where delivery_date is less than order_date, and its giving wrong answer, so updated query will be SELECT ROUND (AVG (IF(orderDate = deliveryDate, 1, 0)), 4) * 100 AS immediate_percentage FROM ( SELECT MIN(order_date) AS orderDate, MIN(customer_pref_delivery_date) AS deliveryDate FROM Delivery WHERE order_date

[@himanshugupta2486]

thanks bro, i was struggling with this test case past half an hour

[@deveshsharma-u2l]

Thanks , Keep going

[@jatinmanhas4966]

kya samjaya hai really amazing 😍

[@StartPracticing]

Thank you

[@VivekKumar-mg3fj]

Mam , very good explaination. Thank you

[@StartPracticing]

Thank you

[@ArshdeepSingh-cb1vq]

Mam Boolean algebra topic karwa deo ji please 😢