sql queries aanpassen en 1 kleine database verandering aanbregen


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 is the month for, movie store queries sql, queries sql, wrapper queries sql, tecdoc database sql queries, sharepoint form queries sql, important queries sql server, queries sql 10g, access queries accpac sql database, building search queries sql, virtuemart queries sql, tree queries sql, insert en asp con sql server, sql 2000 running sum total, can write queries sql envoriment need, running sum total sql update, add database sql, asterisk call forward database sql query, store image database sql fileupload, news scroller sql database, run multiple mysql database queries php send xml

Acerca do Empregador:
( 0 comentários ) Netherlands

ID do Projeto: #10501676

Premiar a:


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)

13 freelancers are bidding on average €29 for this job


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)

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)

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)

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)

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)

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)

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)

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)

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)

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

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

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 [url removed, login to view] forward to chat with u Regards, Luqman

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

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)

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)

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)