PHPMem v2.0.1
Version
1.6.45
Uptime
16 days 1 hour 47 minutes 51 seconds
Memory
Total
512MB
Used
10,16MB (1.98%)
Free
501,84MB
Keys
Current
12 252
Total (since start)
35 898
Evictions
0
Reclaimed
743
Expired Unfetched
0
Evicted Unfetched
0
Connections
Current
14 / 1 024 max
Total
183 572
Rejected
0
llm:82f476109ff11db675646a00deed1938d6ca17904b1192521c233ced0cc472f6
Edit
```json
{
"queries": [
{
"query": "SELECT winner, COUNT(*) AS wins FROM \"IPL_Matches_Data_2008_2026\" WHERE winner IS NOT NULL GROUP BY winner ORDER BY wins DESC LIMIT 10",
"description": "Top 10 teams by total match wins across all IPL seasons."
},
{
"query": "SELECT season, COUNT(*) AS matches FROM \"IPL_Matches_Data_2008_2026\" GROUP BY season ORDER BY season DESC",
"description": "Number of matches played in each IPL season."
},
{
"query": "SELECT venue, COUNT(*) AS matches FROM \"IPL_Matches_Data_2008_2026\" GROUP BY venue ORDER BY matches DESC LIMIT 10",
"description": "Top 10 most frequently used venues in IPL history."
},
{
"query": "SELECT player_of_match, COUNT(*) AS awards FROM \"IPL_Matches_Data_2008_2026\" WHERE player_of_match IS NOT NULL GROUP BY player_of_match ORDER BY awards DESC LIMIT 15",
"description": "Players with the most Player of the Match awards."
},
{
"query": "SELECT city, AVG(team1_runs + team2_runs) AS avg_total_runs FROM \"IPL_Matches_Data_2008_2026\" WHERE team1_runs IS NOT NULL AND team2_runs IS NOT NULL GROUP BY city ORDER BY avg_total_runs DESC LIMIT 10",
"description": "Cities with the highest average total runs per match."
},
{
"query": "SELECT result_type, COUNT(*) AS count FROM \"IPL_Matches_Data_2008_2026\" WHERE result_type IS NOT NULL GROUP BY result_type ORDER BY count DESC",
"description": "Distribution of match results by result type (runs, wickets, etc.)."
},
{
"query": "SELECT toss_winner, toss_decision, COUNT(*) AS count FROM \"IPL_Matches_Data_2008_2026\" WHERE toss_decision IS NOT NULL GROUP BY toss_winner, toss_decision ORDER BY count DESC LIMIT 10",
"description": "Teams' toss decisions and their frequency."
},
{
"query": "SELECT season, MAX(team1_runs) AS highest_team_score FROM \"IPL_Matches_Data_2008_2026\" WHERE team1_runs IS NOT NULL GROUP BY season ORDER BY season DESC",
"description": "Highest team score in each IPL season."
},
{
"query": "SELECT team1, team2, COUNT(*) AS encounters FROM \"IPL_Matches_Data_2008_2026\" WHERE team1 = 'Mumbai Indians' AND team2 = 'Chennai Super Kings' GROUP BY team1, team2",
"description": "Number of matches between Mumbai Indians and Chennai Super Kings."
},
{
"query": "SELECT venue, city, COUNT(*) AS matches FROM \"IPL_Matches_Data_2008_2026\" WHERE city = 'Mumbai' GROUP BY venue, city ORDER BY matches DESC",
"description": "Match distribution across different venues in Mumbai."
}
]
}
```