Assume that we have the following tables, with columns as indicated: Rides ride_id start_time end_time passenger_id driver_id ride_region is_completed (Y/N) Drivers driver_id onboarding_time home_region 1) Write a query that we could use to create a plot of the total count of rides completed in our San Francisco region, in each week over the last 12 weeks. 2) For each week over the last 12 weeks, write a query that will return a count of the total drivers who gave at least one ride. And only for driver’s based in San Francisco.
