SQL Codes Project

₱440-1200 PHP

Completed

Posted

almost 9 years ago

₱440-1200 PHP

Paid on delivery

give the codes answering the following questions.. the data will be given along with this project. i need a sql codes for this. questions: 1. What item has the best profit 2. What is the most profitable region 3. What item has the most stock 4. Which supplier supplies the company most 5. How much profit% does each region have 6. Display all warehouses with corresponding profits from most profitable 7. In what date week did we acquire the most products in value (not in quantity) 8. Display all suppliers with their weekly total sales to the company 9. Display all regions’ profits from least profitable 10. How many kitchen items did we sell, how much? 11. How much did we sell all the chocolates for? How many? 12. How much money will the company lose from expired products if items are not sold after May 30, 2012 13. Display all total sales of each region from the most profitable 14. What type is the weakest in sales 15. In your opinion, what warehouse will you close down in terms of total profits? 16. From which supplier will you get the items from the most from their price to the company?

Microsoft Access

MySQL

SQL

Project ID: 8234855

About the project

13 proposals

Remote project

Active 9 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@desconit

Hi, I have 10 years of industry experience in database development. I\'m expert of writing SQL quires, stored procedure and functions. I work on SQL Server, MS-Access, My SQL and Oracle. I can provide you the queries (SQL code) with in a day. Please let me know if you are interested to proceed. Regards, Farooq

₱550 PHP in 1 day

5.0

(28 reviews)

6.1

13 freelancers are bidding on average ₱956 PHP for this job

@vinaysinghh

I am Oracle DBA having more then 5 yrs of experience in sql Oracle and mysql. I can do this task

₱820 PHP in 5 days

4.8

(55 reviews)

5.1

@nikmah344

Hi, I have imported the mdb file to SQL. If i am not wrong , DO want SQL code , I mean sql query to your 10 questions ?? Right. If Yes then I have imported data to SQL , I can give you 10 question. Let me know if you want same. Or add me on skype (mahajan344)

₱1,040 PHP in 1 day

4.8

(22 reviews)

5.3

@webstruction

Hello sir... i am ready to start your project right away and can give you desired results in 2 hours tops... i assure you, you will be more than satisfied with my work... pls initiate chat so we can discuss about the project at length Regards, Nilesh

₱1,420 PHP in 1 day

5.0

(6 reviews)

4.5

@dekinghtg

Dear sir, So you need sql code to answers those questions? I can provide them for you and start working today. Regards

₱660 PHP in 2 days

5.0

(9 reviews)

4.2

@freelancerwrkr

Hello, I am having professional experience in writing SQL queries. I can complete this task in one day. I would like to work with you. Thanks....

₱1,040 PHP in 1 day

5.0

(6 reviews)

3.0

@ThumbsUpCode

Hi, I dealt with such data/project. let me know if I can get it done for you. Please don't hesitate to contact me if any questions. Thanks,

₱1,200 PHP in 3 days

4.9

(2 reviews)

2.2

@techietech14

3years of hands-on expertise on mysql. Good querying skills with timely delivery. Looking forward to work on this project!

₱1,040 PHP in 1 day

5.0

(4 reviews)

1.8

@Alexhomie

Предложение еще не подано

₱1,040 PHP in 3 days

0.0

(0 reviews)

0.0

@fafad

A proposal has not yet been provided

₱940 PHP in 1 day

0.0

(0 reviews)

0.0

@shayal009

This project is database oriented. This is to create a database for a stock market and allow the user to execute the queries. I m very familiar to SQL and I did project on fee management that was also database oriented same as it that experience will help me to do it properly. I have planned to do this project by the following criterion- At first I will create tables to arrange these fields to MySQL database by linking all the tables via foreign key then write the SQL queries to find the result of following queries. Please provide me a chance to show my knowledge and I m willing to do this project. thank you sir please contact me for further details. hope to hear from you. Your sincerely Shayal Chhabra

₱1,040 PHP in 1 day

0.0

(0 reviews)

0.0

@danmoy08

Software Engineer. Currently working as a developer at Herjavec Group and working on building a database using SQL. First answer is SELECT MAX(Retail_Price-Base_price)

₱620 PHP in 1 day