Sedang Disiapkan

Write SQL queries for the Hotel System on MS Access (Due is Today Evening)

Write SQL queries for the Hotel System on MS Access. These queries should serve some business functions. You need to list all queries and a brief explanation of the purpose of each query. Output of all queries will also be included. You should write at least 3 single-table queries and at least 7 multi-table queries. The following 5 queries have to be designed. You can design any other 5 queries depending on your system.

Find the names of customer having at least stayed twice last 18 months.

Find the most valuable Customer (paying most) during last 24 months.

Find the most preferable/popular room type (Look at the reservation)?

What is the total revenue for the year 2012.

Find the average price of rooms where "smoking is allowed" and average price of rooms where "smoking is not allowed". (Hint: May need to use GROUP BY).

Which room type has been reserved most?

Any additional features that you may have included that enrich the project will also be included.

Waiting for your bids. Thanks.

Kemahiran: Microsoft Access, SQL

Lihat lebih lanjut: write names, write design brief need, sql price, look find write, access group, sql microsoft access, microsoft project price, microsoft access sql, write sql project, sql queries, sql microsoft, sql business, queries, microsoft access business, hotel system, evening, query reservation hotel, project 2013 access, access query table, access brief, enrich, sql microsoft project, group write, design hotel system, write sql queries

Tentang Majikan:
( 29 ulasan ) Istanbul, Turkey

ID Projek: #4099714

Dianugerahkan kepada:

lokeshk9936

Hi, I can do this now. Please see PM

$30 USD / jam
(3 Ulasan)
2.8

7 pekerja bebas membida secara purata $17/jam untuk pekerjaan ini

expertcoder1vw

Access expert can do this job for you. Bests, Larry

$8 USD / jam
(41 Ulasan)
5.8
weonlydo

Sure, I'd like to do your homework for you

$50 USD / jam
(19 Ulasan)
5.0
manhpham

Please let's me help you.

$12 USD / jam
(12 Ulasan)
4.3
omprakash1981

Hi sir, please send me more details about the database and job.

$8 USD / jam
(0 Ulasan)
0.0
momtazdhaka

**I AM ONE OF THE TOP 10% VB EXPERTS AROUND THE WORLD!!** About me: I am a Bank's Database Administrator and Programmer (www.sonalibank.com.bd). I have obtained Graduate & Post-Graduate Degree in English Language & Lagi

$4 USD / jam
(0 Ulasan)
0.0
samparkweb

Ready to start...

$10 USD / jam
(0 Ulasan)
0.0
muhammadibaad

Sir, I have expertise in SQL and MS Access,i shall write quries as per your requirment. Thanks.

$6 USD / jam
(0 Ulasan)
0.0