Group Tenants by Shared Rent

Problem

Table: `Tenants`

```text
+-------------+---------+
| Column Name | Type |
+-------------+---------+
| tenant_id | int |
| tenant_name | varchar |
| rent | int |
+-------------+---------+
tenant_id is the primary key for this table.
Each row gives a tenant's ID, name, and the monthly rent they pay.
```

A building manager wants to bundle tenants into rent groups for a survey. A group must contain **at least two** tenants, and every tenant in a group pays the **same rent**. All tenants paying the same rent must land in the same group. A tenant whose rent amount is unique belongs to no group.

A group's `tier_id` is the rank of its rent in **ascending** order: the cheapest qualifying rent is tier 1, the next is tier 2, and so on.

Write a solution to report each grouped tenant together with their `tier_id`.

Return the result table ordered by `tier_id` ascending, then by `tenant_id` ascending.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 5 rows with the columns tenant_id, tenant_name, rent, tier_id.

Starter code (SQL)

SELECT *
FROM Tenants;

Related SQL questions

• 3-Day Tweet Rolling AverageMedium
• 7-Day vs 28-Day Rolling Avg DivergenceMedium
• A/B Test Sample Ratio Mismatch (SRM) CheckMedium
• Accounts Streaming From Two Devices at OnceMedium
• Ad Campaign Funnel AnalysisMedium
• Agent Resolution RateMedium