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 lagi: sql queries hotel system access, find names customer stayed twice last months, write names, write a design brief for the need, sql price, look find and write, for the design, access group, what is ms sql, what is ms access, what is microsoft project, sql microsoft access, ms project price, ms access sql, microsoft project price, microsoft access sql, write some sql for a project, write query, sql queries, sql microsoft, sql business, queries, ms access 2013, microsoft access for business, hotel system

Tentang Majikan:
( 29 ulasan ) Istanbul, Turkey

ID Projek: #4099714

Dianugerahkan kepada:


Hi, I can do this now. Please see PM

$30 USD / jam
(3 Ulasan)

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


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

$8 USD / jam
(41 Ulasan)

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

$50 USD / jam
(19 Ulasan)

Please let's me help you.

$12 USD / jam
(12 Ulasan)

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

$8 USD / jam
(0 Ulasan)

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

$4 USD / jam
(0 Ulasan)

Ready to start...

$10 USD / jam
(0 Ulasan)

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

$6 USD / jam
(0 Ulasan)