Back to problems

Trade In Payouts

SQL · Apple · Easy

Description You are given two tables that track Apple's device trade-in program. Table: transactions transaction_id is the primary key. Every row represents a single trade-in event at a particular store for a specific device model. Table: models model_id is the primary key. Each row holds the cash payout value assigned to a device model in the trade-in program. When a customer trades in an old iPhone, they receive the model's payout amount in cash. For each store, compute…

Checking your access…