Back to Browse

Learn SQL | Danny Ma's 8 Week SQL Challenge Walkthrough | Case Study 2 Pizza Runner Section B

3.5K views
Feb 3, 2023
22:46

In this video, I walk through my solution to Case Study 2/Week 2 Pizza Runner Section B of Danny Ma's 8 Week SQL Challenge. Challenge: https://8weeksqlchallenge.com/case-study-2/ Solution Script: https://github.com/wjsutton/data_with_danny_8_week_sql_challenge 00:00 Intro & schema 01:20 Q1 - Runner signups 03:28 Q2 - Avg pickup time 07:08 Q3 - Number of pizzas vs. prep time 09:39 Q4 - Avg distance travelled 13:18 Q5 - Longest vs. shortest delivery time 17:43 Q6 - Avg runner speed 20:38 Q7 - Delivery percentage 22:34 Outro

Download

1 formats

Video Formats

360pmp435.8 MB

Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.

Learn SQL | Danny Ma's 8 Week SQL Challenge Walkthrough | Case Study 2 Pizza Runner Section B | NatokHD