Interview Query

Audio Chat Success

2
Have you seen this question before?

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
  1. How would you measure the success of this new feature?
  2. Write a query that can represent if the feature is successful or not.
Next question: Variable Error
.....
MySQL 8.0.17
Loading editor
Use Shift + Enter to run query