MedVision ad

comp114 assignment (1 Viewer)

pb

Inside The Hollow
Joined
Jan 20, 2004
Messages
775
Location
Westie!
Gender
Female
HSC
2003
plz help =/
does anyone know how to do q5?
i would get it if we could assume that we know the hotel_no, but we can't
so yeh... im stuck :(
 

choco

love the mini xxl!
Joined
Aug 11, 2003
Messages
752
Location
sydney
Gender
Female
HSC
2003
you can specify that hotename= 'windsor' instead, make sure you select hotelname tho...
can you help me with the question that says total number of rooms in each hotel?
 

doe

Member
Joined
Jan 23, 2004
Messages
751
Gender
Undisclosed
HSC
N/A
the assignment section is password protected, post a copy somewhere or mail it to me and ill have a look
 

doe

Member
Joined
Jan 23, 2004
Messages
751
Gender
Undisclosed
HSC
N/A
im just kinda going off my sql memory, i havent run these

the q5 is something like this

select room.room_no, room.r_price, room.r_type from room, hotel where rooms.hotel_no = hotel.hotel_no and hotel.h_name = 'windsor'

the how many rooms is something like

select hotel.h_name, count(room.room_no) from room, hotel where room.hotel_no = hotel.hotel_no

or more probably this

select hotel.h_name, room.room_no from hotel, room where where room.hotel_no = hotel.hotel_no
 

pb

Inside The Hollow
Joined
Jan 20, 2004
Messages
775
Location
Westie!
Gender
Female
HSC
2003
thanks
could u help me with q10 as well plz?
 

hibs19

New Member
Joined
Feb 24, 2004
Messages
6
HeLp!!

anyone.. can we get some help here for question 9 and 10!! please all u smart comp ppl hElp us all!!
thanx guys!!
 

...

^___^
Joined
May 21, 2003
Messages
7,723
Location
somewhere inside E6A
Gender
Male
HSC
1998
pb

my q10 is wrong
it counts up to 4, but the answer should be 5

cos i can't work out how to count when it is from 31-jul-01 to 01-sep-01
 

Grizzly

euphoric
Joined
Jul 9, 2003
Messages
2,414
Location
there
Gender
Undisclosed
HSC
2003
"hibs19
New Member


Join Date: Feb 2004
Posts: 6 "

ooooo... fresh meat at MQ :p
 

AsyLum

Premium Member
Joined
Nov 13, 2002
Messages
15,899
Gender
Undisclosed
HSC
N/A
Grizzly said:
"hibs19
New Member


Join Date: Feb 2004
Posts: 6 "

ooooo... fresh meat at MQ :p
Haha, wait till the new batch comes ;)
 

jlh

sooner or later...
Joined
Mar 15, 2003
Messages
1,755
Location
Sydney
Gender
Male
HSC
2002
more stalking victims for you huh grizzly?
and he/she is in the same division as you......


i think your thread pb is going to be hi- jacked again!! :S
 
Last edited:

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top