Total grocery sales in SQL
Hard
You are given the below tables, showing Store, Product, and Sales information for a chain of grocery stores. The columns are labeled in such a way that you should be able to interpret what each field is showing.
Store
| store_id | location |
|---|---|
| 91110 | New York |
| 99525 | Los Angeles |
| 37340 | Tokyo |
| 32016 | Detroit |
| 57507 | London |
Product
| product_id | product_name | price_usd |...
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...