This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Data Analyst at DoorDash. The finance team wants to understand tipping behavior and how much of each order total goes toward platform fees. For every order, you need to compute two derived metrics: the tip as a percentage of the food subtotal, and the combined delivery and service fees as a percentage of the total amount charged.
You are a Data Analyst at DoorDash. The finance team wants to understand tipping behavior and how much of each order total goes toward platform fees. For every order, you need to compute two derived metrics: the tip as a percentage of the food subtotal, and the combined delivery and service fees as a percentage of the total amount charged.