SQL Codes Project

₱440-1200 PHP

Complété

Publié

il y a presque 9 ans

₱440-1200 PHP

Payé lors de la livraison

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

N° de projet : 8234855

Concernant le projet

13 propositions

Projet à distance

Actif à il y a 9 ans

Cherchez-vous à gagner de l'argent ?

Adresse e-mail

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais

Soyez payé pour votre travail

Surlignez votre proposition

Il est gratuit de s'inscrire et de faire des offres sur des travaux

Décerné à :

@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 en 1 jour

5,0

(28 commentaires)

6,1

13 freelances proposent en moyenne ₱956 PHP pour ce travail

@vinaysinghh

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

₱820 PHP en 5 jours

4,8

(55 commentaires)

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 en 1 jour

4,8

(22 commentaires)

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 en 1 jour

5,0

(6 commentaires)

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 en 2 jours

5,0

(9 commentaires)

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 en 1 jour

5,0

(6 commentaires)

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 en 3 jours

4,9

(2 commentaires)

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 en 1 jour

5,0

(4 commentaires)

1,8

@Alexhomie

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

₱1 040 PHP en 3 jours

0,0

(0 commentaires)

0,0

@fafad

A proposal has not yet been provided

₱940 PHP en 1 jour

0,0

(0 commentaires)

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 en 1 jour

0,0

(0 commentaires)

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 en 1 jour