Highest percent of revenue in store
Hard
Suppose you're given the following tables called 'orders' and 'order_info'. The table 'orders' shows revenue values for unique orders along with the associated channel ('online' or 'in_store') while the table 'order_info' shows the order's ID along with its location.
Table: orders
| order_id | channel | date | month | revenue |
|---|---|---|---|---|
| 1 | online | 2020-09-01 00:00:00 | 9 | 100 |
Sign in to InterviewQs to view this question
Or
New to InterviewQs? Sign up now.
By proceeding, you agree to our Terms and Conditions and Privacy Policy.
Loading editor...