Find Jobs
Hire Freelancers

Answer SQL Questions

$10-30 USD

Completed
Posted over 9 years ago

$10-30 USD

Paid on delivery
Answer SQL Questions below. I need this completed in less than 1 day. ---- Imagine you have the following three tables in the database: Guest, Consumption, and Property. And each of the tables contains some useful information: Guest (Table is unique on GUEST_ID) GUEST_ID Unique guest ID MBR_ID membership ID MBR_TIER membership tier (There are 5 tiers: A, B, C, G, and P) Consumption (Each record indicates a stay; a guest could have more than 1 stay) GUEST_ID Guest ID for the guest who stayed at the hotel PROP_ID Property ID (the unique ID of the hotel where the stay occurred) ARV_DATE The arrival date of the stay ROOM_REV The room revenue of the stay ROOM_NIGHT Number of room nights of the stay Property PROP_ID Unique property ID BRAND Brand name of the property (Four different brands - Sheraton, Westin, W, and Four Points) Question 1. Write a SQL code to create a table which summarizes the number of stays and total room revenue in 2009 for each of the membership tiers. E.g. MBR_TIER NUM_STAY ROOM_REV A 5,300 $689,900 B 6,800 $909,500 C 10,000 $150,000,100 ... Question 2. Write a SQL code to complete a summary table: 1. The table has a new column called Segment. Its value is based on the average daily room rate for 2009 (ADR). If ADR is more than $500, then segment is ‘High’. If ADR is between $100 and $500, then segment is ‘Medium’. If ADR is less than $100, then segment is ‘Low’. (Note: Average daily room rate of a guest = total room revenue / total number of room nights) 2. The table summarizes the number of guests and number of stays by brand and segment. E.g. Brand Segment Num_Guest Num_STAY Sheraton Low 10,000 32,000 Sheraton Medium 8,000 19,000 Sheraton High 5,000 18,500 Westin Low 9,500 29,500 Westin Medium 6,700 24,300 Westin High 5,200 22,000
Project ID: 6277030

About the project

5 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, I have read the question you posted and the schema you gave. I have skills in mySql as well SQL P-SQL, and it is an easy task for me to answer these questions. I can write optimize queries. Regards.
$30 USD in 1 day
0.0 (0 reviews)
1.0
1.0
5 freelancers are bidding on average $45 USD for this job
User Avatar
Hello, I am very much interested to do this work as i am experienced a lot in writing complex SQL queries. I understand your requirements & i think i can write these queries efficiently. Looking forward to have a a positive response from you. Thanks
$30 USD in 1 day
5.0 (187 reviews)
7.3
7.3
User Avatar
Hello, With 99% completion rate, 700 successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page !!)... you can never go wrong choosing me :) I look forward to your reply. Thanks. Kind Regards, Rajesh Soni
$105 USD in 1 day
5.0 (33 reviews)
5.8
5.8
User Avatar
php mysql expert here with 3 years of experience in web development. I am available now and ready to do this for you. lets do it
$30 USD in 1 day
5.0 (3 reviews)
2.6
2.6
User Avatar
A proposal has not yet been provided
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Brooklyn, United States
4.9
390
Payment method verified
Member since Mar 15, 2005

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.