So I figured out one query with the help here however I want to add one more thing into it now, so from before:

The guest reservation table has the following...

I tried both

select

g.g_name,

datediff(d, r.res_checkin_date, r.res_checkout_date)*p.rate+i.inv_amount

from reservation as r

inner join price_plan as p

on r.price_plan = p.price_plan

inner...

Okay I was able to figure that out (it was because of the timestamp that was involved with the day I didn't realize).

The last query I need help with is...

I'm having trouble getting my queries to return appropriate results for the following queries though:

1. For a given specific date list the guests that are scheduled to check out, grouped...

Yes it is

I have created the following:

create table villa(

villa_ID INT,

phone_ext varchar(10),

villa_type char(1),

no_of_rooms TINYINT,

no_of_beds TINYINT,

default_price_plan CHAR(1),

);

alter table villa

alter column villa_id int

not null;

alter table villa

add constraint pk_villa primary key (villa_id);

How could I use that...

Another query I wanted help on was that if a guest wanted a certain type of room then if that type of room would be available on the dates they...

Todd that worked, thanks!

For the 1st query I think I'd have to use 3 table; the room table, reservation table and rental table:

Room Table: Room_ID, Room Type

Reservation Table: Confirmation_No, Check_In_Date, Check_Out_Date, Room_Type

Rental Table:...