# Region Cluster Distribution

Use these templates when the user asks for cluster counts broken down by region, provider, or service plan. Because `cluster_id` is unique in the source table, `COUNT(*)` after filters is the cluster count — no DISTINCT needed. See SKILL.md for shared rules.

## Region × provider

For requests like "Show cluster counts by cloud provider and region":

```sql
SELECT
  provider_name,
  region_display_name,
  COUNT(*) AS cluster_count
FROM `gcp-digital-bi.model_tidbcloud.dws_cloud_all_clusters_component_detail_basic_info`
WHERE cluster_service_plan IN ('Starter', 'Essential', 'Premium')
  AND cluster_deleted_time IS NULL
GROUP BY provider_name, region_display_name
ORDER BY cluster_count DESC;
```

## Service-plan distribution (TiDB X)

For requests like "Show active TiDB X clusters split by service plan":

```sql
SELECT
  cluster_service_plan,
  COUNT(*) AS cluster_count
FROM `gcp-digital-bi.model_tidbcloud.dws_cloud_all_clusters_component_detail_basic_info`
WHERE cluster_service_plan IN ('Starter', 'Essential', 'Premium')
  AND cluster_deleted_time IS NULL
GROUP BY cluster_service_plan
ORDER BY cluster_count DESC;
```

## Per-region split by service plan

For region-level distribution with plan breakdown:

```sql
SELECT
  provider_name,
  region_display_name,
  cluster_service_plan,
  COUNT(*) AS cluster_count
FROM `gcp-digital-bi.model_tidbcloud.dws_cloud_all_clusters_component_detail_basic_info`
WHERE cluster_service_plan IN ('Starter', 'Essential', 'Premium')
  AND cluster_deleted_time IS NULL
GROUP BY provider_name, region_display_name, cluster_service_plan
ORDER BY cluster_count DESC;
```