Real Estate in Moscow

The real-estate team is preparing a Moscow listing overview. Output the full record of every property located in the city Moscow.

Expected output sample

This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables. Your answer must use the same column names as this sample — alias them with AS if needed.

id	address	city	property_type	area_sqm	price	rooms
1	Pushkin St. 10	Moscow	apartment	65.5	12500000.00	2
4	Peace St. 22	Moscow	apartment	85.0	18000000.00	3
6	Tverskaya St. 15	Moscow	apartment	95.0	22000000.00	3

Domclick

Your query result will appear here

Focus radio

Paused · SomaFM · Fluid