comp114 assignment (1 Viewer)

[pb]

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]

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]

the assignment section is password protected, post a copy somewhere or mail it to me and ill have a look

 

[pb]

thanks doe

 

[doe]

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]

thanks
could u help me with q10 as well plz?

 

[choco]

yeah it works

 

[hibs19]

HeLp!!

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

 

[...]

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]

"hibs19
New Member


Join Date: Feb 2004
Posts: 6 "

ooooo... fresh meat at MQ

 

[sukiyaki]

"hibs19
New Member


Join Date: Feb 2004
Posts: 6 "

ooooo... fresh meat at MQ

leave the poor noobs alone

 

[AsyLum]

"hibs19
New Member


Join Date: Feb 2004
Posts: 6 "

ooooo... fresh meat at MQ

Haha, wait till the new batch comes

 

[jlh]

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