Audio Chat Success
Start Timer
0:00:00
An online marketplace company has introduced a new feature that allows potential buyers and sellers to conduct audio chats with each other prior to transacting.
Let’s say we have two tables that represent this data.
Example:
Input:
chats table
| Column | Type |
|---|---|
id |
INTEGER |
buyer_user_id |
INTEGER |
seller_user_id |
INTEGER |
call_length |
INTEGER |
call_connected |
INTEGER |
marketplace_purchases table
| Column | Type |
|---|---|
id |
INTEGER |
buyer_user_id |
INTEGER |
seller_user_id |
INTEGER |
item_id |
INTEGER |
purchase_amount |
FLOAT |
- How would you measure the success of this new feature?
- Write a query that can represent if the feature is successful or not.
.
.
.
.
.
.
.
.
.
Comments