Allocating forecast to deeper granularity in SQL

Hard

You're given the following tables, called 'sales_forecast' and 'current_inventory'. The 'sales_forecast' table shows projected sales volume (in terms of # of units) by location by year. The 'current_inventory' shows the current # of units available by location and by color. The tables are shown below:

Table: sales_forecast

yearlocationfcst_num_sales
2021New York113456

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