Assume that we have the following tables, with columns as indicated: Table Name: Rides Columns: ride_id, start_time, end_time, passenger_id, driver_id, ride_region, ride_completed (Y/N), pick_up_location (lat/long), drop_off_location (lat/long), distance between_pickup_and_dropoff Table Name: Drivers Columns: driver_id, first_name, last_name, onboarding_time, home_region Table Name: Passenger Columns: passenger_id, first_name, last_name, 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) Write a query that returns a count of the total number of weekly drivers based in San Francisco to complete at least one ride, in each week over the last 12 weeks. We notice that ride counts fluctuate in a pattern depending on the day of the week. We want to remove the effect of these daily fluctuations so that we can see trends occurring on a week by week basis. 3) Write a query that returns, for each of the last 90 days, a count of the rides taken in the 7 day window preceding that day. Part C-part of presentation to the panel. The candidate needs to prepare a slideshow presentation and share it with the recruiting team prior to the interview. Lyft offers incentives to drivers to give over a certain number of rides per week (e.g. give more than 100 rides per week and receive an extra $200 for the week). Certain drivers will attempt to game this offer by giving frequent rides to friends or family members for short distances to ensure they meet the incentive threshold. 4) How would you detect this activity? 5) What actions would you take against these drivers once detected? 6) What strategies would you put in place to disincentivize this behavior?