Is this a imple Query?

[Peer Jones]

Hi,

Please excuse this dumb question, but I'm not a developer and perhaps it'll give you something to grin about. Anyway, here goes:

I have a simple table containing three columns (I've simplified the examples):

1) A list of streets
2) a list of housenumbers for each of the above streets.
3) A simple indicator whether each housenumber is occupied or not.

I just want a result of a query that gives me the information in which of the streets all houses are occupied, which streets are partially occupied, and which streets are not occupied. What makes this tricky for me is that the result should only contain one row of the required information per street.

I just can't figure it out. Any help, please?