With 1.7 million freelancers, we'll match you with the perfect talent.
The client has made the following changes to the job.
Bidding period ended early.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
We need to output a list of records meeting set conditions from Excel sheets, preferably using a SQL query. The data is contained in 3 Excel sheets:
* Sheet1 is a list of inventory items, we need to filter out items that match a date range and item category type
* Sheet2 is a list of inventory items in retail stores to be joined to sku numbers in sheet1.
* Sheet3 is a list of inventory items in a warehouse to be joined to sku numbers in sheet1. An inventory iitem may be contained in multiple warehouse locations. Same join of the sku numbers found in sheet1.
Obejctive: Output a list of inventory detail in the warehouse locations (sheet) and inventory detail in stores (sheet2) based on the filtered dates and inventory cateogry in sheet1.
Sign in or Register to see more