Highest grossing items by location, without primary keys
Hard
Suppose you're given the following tables, showing item prices by location as well as item sales by location:
Table: item_prices_by_location
| city | item_name | price |
|---|---|---|
| New_York | Coat | 115 |
| New_York | Hat | 40 |
| New_York | Shirt | 65 |
| New_York | Pants | 90 |
| Los_Angeles | Coat | 110 |
| Los_Angeles | Hat | 35 |
| Los_Angeles | Shirt | 60 |
| Los_Angeles | Pants | 85 |
| Austin | Coat | 105 |
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...