Counting records

[Ashkan]

Hello people,

I have two tables, the first one is House which contains the attribute House Name, the second table is House Room which contains attributes about the room.

My question is how would I go about finding out how many rooms are in each house?

I hope this makes sense

Thanks

 

[WayneRyan]

AshKan,

Select HouseName, Count(*) As NumberOfRooms
From   HouseRoom
Group By HouseName

Wayne