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
13 freelancers estão ofertando em média €29 para este trabalho
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!!
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
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
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.
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