Avg. sales by location 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_idlocation
91110New York
99525Los Angeles
37340Tokyo
32016Detroit
57507London

Product...

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...