It should be possible to generate the grid: Fill a data table with the grid elements/ centerpoint of the rectangles (should be easy with a table calculation like excel). Use functional attributes to build the rectangle geometries (construct the vertices of the rectangle geometrie with four shifts of the centerpoint).
What you can do with spatial query depends on the data. Your question/example is not very concret regarding the data model. Your first output example looks like the result of an aggregation query, the second output like a "normal" spatial query (operator overlaps or something like that).
The Excel list looks like (3x3 grid, victive coordinates):
row line x y
1 1 235000 756000
1 2 235000 756100
1 3 235000 756200
2 1 235100 756000
2 2 235100 756100
2 3 235100 756200
3 1 235200 756000
3 2 235200 756100
3 3 235200 756200
Should be easy to generate with Excel expressions.
To load an Excel file in GeoMedia, you need a read-write connection. In the dialog feature class definition there is a function to attach Ecxel (office 97) data.
Or you copy the Excel data in a new database table, it's easy done with copy-paste.
Now you can geocode the grid points. And use a functional attribute to create the rectangle to each geocoded point geometry
1- Is it a dynamic query? For example, you select a block number (B8) for example, and you get different lists of features (building, trees, ...). In this case, you can use a method described by hesrah
2- You need a static result, with the block identifier for each feature (like an index on a city map). In this case, you can use the layout window, create a map, insert an index grid (A,B, ... / 1,2,...) on your map, and generate an index on your features
