Assume that we have the following tables, with columns as indicated: Table Name: Rides Columns: ride_id,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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? 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?
Expert Answer:
Answer rating: 100% (QA)
As an AI developed by OpenAI I must clarify that I cant execute actual SQL queries on databases or create physical plots However I can provide the SQL queries to answer your questions and you would th... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these databases questions
-
Morning Dove Company manufactures one model of birdbath, which is very popular. Morning Dove sells all units it produces each month. The relevant range is 0 to 1,500 units, and monthly production...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
If the Albany highway system described in Problem 29 has revised flow capacities as shown in the following network, what is the maximal flow in vehicles per hour through the system? How many vehicles...
-
Draw a line-bond structure for the propyne, CH3C CH; indicate the hydribization of each carbon; and predict a value for each bond angle.
-
Verify that the results, Eqs. (7.15) and (7.24), depended only on g00: the form of gxx doesn't affect them, as long as it is 1 + 0(). Eq. (7.15) d/d p0 = - m / . Eq. (7.24) dpi / d = - m, jij,
-
Thomas Brookie went shopping in the Winn Dixie Supermarket. He purchased his items and brought them to the car without incident. He then made additional trips in and out of the store to get empty...
-
Clynne Resources expects earnings this year to be $2 per share. Clynne plans to pay a dividend of $0.70 for the year. During the year Clynne expects to borrow $10 million in addition to its already...
-
Kericho Sports Club has been operating for some time now. The treasurer analysed the cash book and produced the following Receipts and Payments account for the year ended 31st Dec. 2018. Receipts...
-
The following account balances are for Lisa Assaad, Certified Public Accountant, as of April 30, 20X1. INSTRUCTIONS Using the accounting equation form, determine the balance for Lisa Assaad, Capital,...
-
An electron is located at coordinates (-a, a); another electron is located at coordinates (-a, -a); a third electron is located at coordinates (a, -a), as shown in the figure below. Each electron has...
-
In just three _____________ time, _____________ transfer request was approved. a. weeks, Evangelines b. weeks, Evangelines c. weeks, Evangelines For the above sentence, write the correct letter in...
-
As suggested by the committee we must first secure funding then we can consider expanding overseas. For the above sentence, insert any necessary semicolons, commas, or colons. Count the number of...
-
You have promised your parents (spouse, partner, relative, or friend) that you would submit a progress report at this time. Your Task. Prepare a progress report in letter format in which you do the...
-
For example headquarters decides how tasks responsibilitiesand territories are assigned to our reps. For the above sentence, insert any necessary commas. Count the number of commas you add. Write...
-
Although it is highly recommended that new grads complete and maintain a LinkedIn profile, some critics charge that LinkedIn is a waste of time because it has become bogged down with spam connection...
-
A low pass filter composed of ideal components has a 3dB cutoff frequency of 1GHz. There is a 33 dBm signal at the cutoff frequency being injected into the LPF. a) How much power does this represent...
-
Suppose the concentration of glucose inside a cell is 0.1 mm and the cell is suspended in a glucose solution of 0.01 mm. a. What would be the free energy change involved in transporting 10-o mole of...
-
Robert Ramos (age 36) is a single taxpayer, living at 8765 Bay Dr., Monterey, CA 93940. His Social Security number is 976-23-5132. Robert's earnings and income tax withholding as the manager of a...
-
Sophie is a single taxpayer. For the first payroll period in October 2012, she is paid wages of $3,250 monthly. Sophie claims three allowances on her Form W-4. a. Use the percentage method to...
-
Quince Corporation has taxable income of $450,000 for its 2012 calendar tax year. Calculate the corporation's income tax liability for 2012 before tax credits. $_________
-
When GTE Sylvania discovered it was losing market share to other television manufacturers, it developed a franchise plan that limited the number of retailers selling its product in each area....
-
Megan Murphy and Joseph McGoldrick began dating in July 2010 and eventually decided to marry. In late 2016, Megan and Joseph decided to purchase a home for \($205,000.\) Because Joseph had the...
-
Nelson Rodriguez and Belinda Georgeson had a daughter together and had been living together since some time in 2012. In June 2015, Rodriguez became physically abusive with Georgeson. Rodriguez was...
Study smarter with the SolutionInn App