You are given the following tables, containing information about phone calls that a company receives as well as the company's sales.
all_sales
| date | order_id | customer_id | order_source | phone_call_id | order_total | num_items |
|---|---|---|---|---|---|---|
| 2019-12-20 | 00001 | 0001 | online | 0 | 50 | 1 |
| 2019-12-20 | 00002 | 0002 | phone | 4282 | 100 | 2 |
New to InterviewQs? Sign up now.
By proceeding, you agree to our Terms and Conditions and Privacy Policy.
Loading editor...