Day 10 - Uber SQL Interview Question Explained (JSON + Window Functions)

In this video, we solve a realistic Uber-style SQL interview problem using JSON data in SQL Server.
Uber wants to identify the most efficient drivers in each city.
Driver efficiency is defined as:
Efficiency = Fare / Trip Duration (minutes)

Using a table that stores trip data as JSON, we will:

• Extract fields using JSON_VALUE
• Parse semi-structured data
• Calculate driver efficiency scores
• Use window functions to rank drivers
• Identify the top drivers per city

👉 Try a free SQL mock interview + get personalized feedback:
https://forms.gle/BZ59pNniHhRYHuzq6
👉 For structured SQL interview prep , Get the SQL Interview Accelerator here: https://knowstar.gumroad.com/l/xykisk/k2cx6xm

Dataset and SQL Code here -
https://github.com/learnknowstar-cpu/FAANG-SQL-Bootcamp

Must Do Data Analytics Certifications -

Google Data Analytics Professional Certificate - https://imp.i384100.net/OR37oQ

Google Advanced Data Analytics Professional Certificate - https://imp.i384100.net/eK1WmQ

Please do not forget to like, subscribe and share.

For enrolling and enquiries, please contact us at
Website - https://knowstar.gumroad.com/
Instagram - https://www.instagram.com/learn.knowstar/
Blog - http://know-star.blogspot.com/
Linkedin - https://www.linkedin.com/company/learn-at-knowstar/
Instructor’s LinkedIn - https://www.linkedin.com/in/kriti-c-a83503145/
Email - learn@knowstar.org

Видео Day 10 - Uber SQL Interview Question Explained (JSON + Window Functions) канала Learn at Knowstar