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
| year | location | fcst_num_sales |
|---|---|---|
| 2021 | New York | 113456 |
New to InterviewQs? Sign up now.
By proceeding, you agree to our Terms and Conditions and Privacy Policy.
Loading editor...