Completed

Analyze Order Information

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.

Skills: Excel, MySQL, SQL

See more: excel sql create, convert excel data sql, sku list excel, excel sql table using, excel sample order list, excel work order, convert spreadsheet sql, order list excel, product order table, order sample, product look sku, order spreadsheet, spreadsheet order, analyze number, silverlight business application db table, prestashop adding additional information order details, information order processing application, G7, convert row column excel, compare files db table vb net

About the Employer:
( 245 reviews ) somerville, United States

Project ID: #7526709

Awarded to:

liyanagamageisur

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.

$10 USD in 1 day
(0 Reviews)
0.0

16 freelancers are bidding on average $27 for this job

truongnguyen86

Hello there, i'm expert on database technology also data processing, let me help you with this. Waiting for your feedback. Thank you

$50 USD in 1 day
(96 Reviews)
6.0
RSwapnil

Hello, I have read and understood the project. I am ready to start the work from anytime. I assure you the work accuracy and timely delivery of project. About Me: I have vast experience of data entry, Researc More

$35 USD in 1 day
(52 Reviews)
5.3
scsBiswas

I am interested. can we discuss? .

$50 USD in 1 day
(34 Reviews)
4.9
TonmoyRoy111

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

$30 USD in 2 days
(14 Reviews)
3.0
kongjie86

Hello I have read your job description and now exciting for this project. I have strong skill in database administrate and sql query programming. More than 13 years experiences in many of database systems (Oracle, M More

$25 USD in 1 day
(2 Reviews)
2.3
jurboy

Hi! I have 3 good reasons to help you decide on choosing me: A= ACTIVE FREELANCER. I have the right motivation and the right intention to do this task. I am an energetic and positive-minded person. So, I think I More

$30 USD in 1 day
(2 Reviews)
2.0
dashawnpeterson

I can most certainly help you create a spreadsheet for all your orders. My purpose for applying is to fulfill your needs to complete this project

$25 USD in 3 days
(0 Reviews)
0.0
Leexage

A proposal has not yet been provided

$10 USD in 1 day
(2 Reviews)
0.2
taslima439323

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

$25 USD in 7 days
(0 Reviews)
0.0
rahulsarp

Hello Sir , I am looking forward to do this job.. will you elaborate little more what exactly your out put. thank you

$30 USD in 1 day
(0 Reviews)
0.0
y4n3k

I am experienced with this kind of work. 3- years professional experience in providing all kind of reports, very similar to the one requested here. Using vlookups and hlookups and conversion tools in excel, I can easi More

$30 USD in 1 day
(0 Reviews)
0.0
sps2008

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,

$30 USD in 1 day
(0 Reviews)
0.0
sunilkm80

I am expert in excel and SQL and have worked on various data sets. I am ready to be hired . I will deliver this work with 100% accuracy.

$28 USD in 1 day
(0 Reviews)
0.0
umamahait

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

$15 USD in 1 day
(0 Reviews)
0.0
cvisinescu

Hi, I've got 8 years of experience in working with SQL and I'm confident I can do this for you quickly. I'm new to freelancer.com so don't take my experience. I'm keen on wining a project so I can gain experience s More

$10 USD in 1 day
(0 Reviews)
0.0