PHPMem v2.0.1
Version
1.6.45
Uptime
7 days 8 hours 59 minutes 39 seconds
Memory
Total
512MB
Used
13,32MB (2.6%)
Free
498,68MB
Keys
Current
10 162
Total (since start)
11 092
Evictions
0
Reclaimed
157
Expired Unfetched
0
Evicted Unfetched
0
Connections
Current
2 / 1 024 max
Total
64 594
Rejected
0
llm:e2715a98a324eeba35fd6e1cf3980e7992709df45278528f8373089f0366b419
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."
}
]
}
```