Em Andamento

sql queries aanpassen en 1 kleine database verandering aanbregen

Requirements

Deadline: 15-6-2016 at 20: 00 CET

Provide the created queries in a .word file and the improdeve [url removed, login to view] database

with working queries

Create the SQL queries for the questions listed below and :

Make shure that the prices from every order is automatic calculated when a

order is enterd see dropbox for the database

1. The monthly sales of the last month per employee order by persnr;

2. The monthly sales of the last, and current month month per productgroup and

per employe order by sales and productgroup;

3. The expencive product from the moment via a innerjoin

4. The different towns where the guests are coming from.

5. The maximum number seats per location

6. The most expensive menu of the moment

7. What menu is never orderd?

8. Via innerjoin: What alcoholicdrinnk has the hightest alcoholpercentage and

what is the current price the drink?

9. What drink is populair within the summer months? (June, July, august,

september) give also the sales and the persnr

10. The last ammout off orders within the last month per location, and also the

total sum within for the table numbr within this location

* sql syntax bus be valid without the need to editing the sql syntax like this

one BETWEEN #07/04/2016# AND #07/09/2016#

11. How manny guests where where there on last Monday per table and what was

the avridge groupsize on that night

Give the number off guests on the

Habilidades: SQL

Ver mais: sql price, sql create table price, sql 2016 prices, june month, movie store queries sql, queries sql, wrapper queries sql, tecdoc database sql queries, sharepoint form queries sql, important queries sql server, queries sql 10g, building search queries sql, virtuemart queries sql, tree queries sql, add database sql, news scroller sql database

Acerca do Empregador:
( 0 comentários ) Netherlands

ID do Projeto: #10501676

Premiar a:

nitinbohra89

Having 5 years of experience in Database programming. Expert in database designing and programming. Have designed database architecture for so many websites. Have worked in Oracle Corporation so having knowledge of Mais

€30 EUR em 1 dia
(9 Avaliações)
3.6

13 freelancers estão ofertando em média €29 para este trabalho

truongnguyen86

Hello there, i'm expert on SQL, writing complex queries, let me help you with this. Pls share me more your tables and data. Waiting for your feedback. Thank you!!

€50 EUR em 1 dia
(104 Comentários)
6.1
manhpham

Nice to meet you. My name is Manh from Vietnam. I am very confident that I can complete your project with best quality. Please contact me, we can chat/discuss further on your project. Manh

€30 EUR em 1 dia
(26 Comentários)
5.3
mjkaja

Expert in sql programming.I can do all the questions for you in one day. please let me know if we can work together on this. Thanks.

€24 EUR in 5 dias
(4 Comentários)
4.4
saimyousaf

I'm CS Graduate. I'have quite great skills in database. I have studied detailed courses of Databases, Data WareHoursing, Data Mining and Advanced Databases. You can find me very helpful resource for your project. I h Mais

€25 EUR em 1 dia
(8 Comentários)
3.7
ref2

Hi I have 15+ years of experience in developing applications on oracle database. I have bachelor degree in cs, 25 oracle certified trainings and web app dev certificate from University in Chicago. Please share you Mais

€29 EUR in 2 dias
(11 Comentários)
3.4
shahzaib121

Hi Dear I have a lot experience in DataBases. I am Databases Certified from Oracle. I have done many work in Oracle, MYSQL, Access,Postgres Sql Server. I have done all kind of work front end, Back end, Integration Mais

€34 EUR in 2 dias
(7 Comentários)
3.5
itdev15

Hi sir Thank you for your post. I am really interested to work in your project. I have 10 years experience in web development. I have gained enough experiences in web design, javascript, PHP and MYSQL. High Qualit Mais

€25 EUR em 1 dia
(5 Comentários)
2.3
davedcb

Hello, I am interested in your project. I am a software engineer and I have professional experience with SQL. You will provide data inserts for this database? Thank you, Best regards, David

€24 EUR in 5 dias
(7 Comentários)
2.3
kevinsheno

Hi friend, We are a group of 5 programmers that have 4 years experience and now, we are here to do your work, professionally and for the best rate. Message us before buying.

€25 EUR em 1 dia
(0 Comentários)
0.0
ZishanChuhan

I am expert in SQL, Oracle certified professional, can do the task as per your requirements. .

€22 EUR in 3 dias
(0 Comentários)
0.0
MohammadLuqman

Hi Dear, i am web developer with 2 years of experience in SQL Server and related technologies. i am fully confidant to do your work 100% with best quality.looking forward to chat with u Regards, Luqman

€24 EUR in 3 dias
(0 Comentários)
0.0
dat2na

Hello, I'm professional DBA with 8+ years experience. Working as DBA and DB developer in one of the leader company. I have experience of same jobs like SQL Server Administration and development by remotely. I'm top exp Mais

€34 EUR in 2 dias
(0 Comentários)
0.0
techminds4

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have c Mais

€23 EUR em 1 dia
(0 Comentários)
0.0
ramonadun

4+ experience in erp systems 4+ experience in sql - oracle, SQL Server 4+ experience in programming languages

€20 EUR em 1 dia
(0 Comentários)
0.0