SQL Codes Project

₱440-1200 PHP

Slutfört

Publicerad

nästan nio år sedan

₱440-1200 PHP

Betalning vid leverans

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

Om projektet

13 anbud

Distansprojekt

Senaste aktivitet nio år sedan

Ute efter att tjäna lite pengar?

E-postadress

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram

Få betalt för ditt arbete

Beskriv ditt förslag

Det är gratis att registrera sig och att lägga anbud på uppdrag

Tilldelad till:

@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 Om 1 dag

5,0

(28 omdömen)

6,1

13 frilansar lägger i genomsnitt anbud på ₱956 PHP för detta uppdrag

@vinaysinghh

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

₱820 PHP Om 5 dagar

4,8

(55 omdömen)

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 Om 1 dag

4,8

(22 omdömen)

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 Om 1 dag

5,0

(6 omdömen)

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 Om 2 dagar

5,0

(9 omdömen)

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 Om 1 dag

5,0

(6 omdömen)

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 Om 3 dagar

4,9

(2 omdömen)

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 Om 1 dag

5,0

(4 omdömen)

1,8

@Alexhomie

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

₱1 040 PHP Om 3 dagar

0,0

(0 omdömen)

0,0

@fafad

A proposal has not yet been provided

₱940 PHP Om 1 dag

0,0

(0 omdömen)

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 Om 1 dag

0,0

(0 omdömen)

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 Om 1 dag