PHPMem v2.0.1
Version
1.6.45
Uptime
7 days 17 hours 16 minutes 57 seconds
Memory
Total
512MB
Used
8,23MB (1.61%)
Free
503,77MB
Keys
Current
6 304
Total (since start)
11 096
Evictions
0
Reclaimed
298
Expired Unfetched
0
Evicted Unfetched
0
Connections
Current
2 / 1 024 max
Total
71 444
Rejected
0
llm:ef1ed42404af08fa457cbaaed2cb5138d6504d60007f5735115cc78836d44525
Edit
```json
{
"queries": [
{
"query": "SELECT \"Customer Status\", COUNT(*) AS customer_count FROM telco GROUP BY 1 ORDER BY 2 DESC",
"description": "Distribution of customers by status (active, churned, joined)."
},
{
"query": "SELECT \"Churn Category\", COUNT(*) AS churn_count FROM telco WHERE \"Churn Category\" IS NOT NULL GROUP BY 1 ORDER BY 2 DESC",
"description": "Most common reasons customers left, grouped by category."
},
{
"query": "SELECT \"Internet Type\", \"Churn Label\", COUNT(*) AS customers FROM telco WHERE \"Internet Type\" IS NOT NULL GROUP BY 1, 2 ORDER BY 1, 3 DESC",
"description": "Churn rates broken down by internet service type."
},
{
"query": "SELECT \"Contract\", COUNT(*) AS total, SUM(CASE WHEN \"Churn Label\" = 'Yes' THEN 1 ELSE 0 END) AS churned FROM telco GROUP BY 1 ORDER BY 2 DESC",
"description": "Contract type popularity and associated churn counts."
},
{
"query": "SELECT \"State\", COUNT(*) AS customers FROM telco GROUP BY 1 ORDER BY 2 DESC LIMIT 10",
"description": "Top 10 states by customer count."
},
{
"query": "SELECT \"Churn Reason\", COUNT(*) AS occurrences FROM telco WHERE \"Churn Reason\" IS NOT NULL GROUP BY 1 ORDER BY 2 DESC LIMIT 10",
"description": "Top 10 specific reasons customers gave for leaving."
},
{
"query": "SELECT \"Payment Method\", COUNT(*) AS customers FROM telco GROUP BY 1 ORDER BY 2 DESC",
"description": "Breakdown of customers by payment method preference."
},
{
"query": "SELECT \"Offer\", \"Churn Label\", COUNT(*) AS customers FROM telco WHERE \"Offer\" IS NOT NULL GROUP BY 1, 2 ORDER BY 1, 3 DESC",
"description": "Promotional offers and their impact on customer churn."
},
{
"query": "SELECT \"Senior Citizen\", \"Churn Label\", COUNT(*) AS customers FROM telco GROUP BY 1, 2 ORDER BY 1, 3 DESC",
"description": "Churn comparison between senior citizens and younger customers."
},
{
"query": "SELECT \"Paperless Billing\", COUNT(*) AS customers, SUM(CASE WHEN \"Churn Label\" = 'Yes' THEN 1 ELSE 0 END) AS churned FROM telco GROUP BY 1",
"description": "Paperless billing adoption and its relationship to churn."
}
]
}
```