You are provided a set of orders
Convert orders to tables "orders" and "order details"
Delete all shipping costs from "order details"
Remove all orders from the data with order total>$100
Create a list of all of the skus (items) ordered by the number of orders the skus appears in. (in SQL this is count() and groupby() or use whatever other method you like)
Create a column in the spreadsheet (or use a db table) for each of the top 100 sku. See line 6 in the sample spreadsheet.
Create a row for each order (see column B in spreadsheet). If a sku in the order is among the "most common", place the quantity in the correct column (example G7 in spreadsheet).
If a sku in the order is not in the "most common", then simply put "true" in the last column "additional skus".
Then rerun the script using the top 50 skus only and the top 200 skus only.
Your work product is three spreadsheets or tables that look like the sample with 50, 100, and 200 skus as columns.
I have been working as an IT Executive since 2013 and experiences in analyzing order information using MYSQL. I would like to get opportunity for this project. Please kindly select me.
16 freelancers are bidding on average $27 for this job
Dear Sir I can accomplish the job for you. Kindly contact me for further details. I have previously carried out a number of excel related projects. Thanks Tonmoy Roy
Dear sir I am a professional data entry operator. I am able to do this if you instruction me . I am a heard worker and honest . If you award me this project I will deliver you before deadline . Regards TASLIMA
Hi, I can do this job efficiently. I have more than 10 years of experience in this filed. I am flexible about working time and money. I believe work speaks better than words. Hope to have a positive response. Good day,
Dear Client, Good Evening! I kindly request you to consider me for this opportunity.I will deliver the results on time without any errors. Thanks Uma Swaminathan