Write a SQL query using an INNER JOIN and a LEFT JOIN to find properties that have no active listings. Use the properties, markets, and listings tables. Only listings with a status of active should count.
property_id, property_name, and market_nameproperty_id ascending| Column | Type | Description |
|---|---|---|
| property_idPK | INT | Unique property identifier |
| property_name | VARCHAR(150) | Display name of the property |
| market_id | INT | Reference to the property's market |
| Column | Type | Description |
|---|---|---|
| market_idPK | INT | Unique market identifier |
| market_name | VARCHAR(100) | Market name |
| Column | Type | Description |
|---|---|---|
| listing_idPK | INT | Unique listing identifier |
| property_id | INT | Reference to the listed property |
| status | VARCHAR(30) | Current listing status |
| listing_type | VARCHAR(30) | Type of property listing |