PHPMem v2.0.1
Version
1.6.45
Uptime
7 days 4 hours 21 minutes 25 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
60 231
Rejected
0
llm:315c1112b9ea7132b28d79c978eafb94b9880dd089d515bb8c7242adc5492bcc
Edit
```json
{
"queries": [
{
"query": "SELECT \"Country\", \"Happiness Score\" FROM \"2015\" ORDER BY \"Happiness Score\" DESC LIMIT 10",
"description": "Top 10 happiest countries in 2015 by happiness score."
},
{
"query": "SELECT \"Region\", AVG(\"Happiness Score\") AS avg_score FROM \"2015\" WHERE \"Happiness Score\" IS NOT NULL GROUP BY \"Region\" ORDER BY avg_score DESC",
"description": "Average happiness score by world region in 2015, highest to lowest."
},
{
"query": "SELECT \"Country\", \"Economy (GDP per Capita)\", \"Happiness Score\" FROM \"2016\" WHERE \"Region\" = 'Western Europe' ORDER BY \"Happiness Score\" DESC LIMIT 10",
"description": "Top 10 Western European countries by happiness in 2016 with GDP data."
},
{
"query": "SELECT \"Country\", \"Happiness.Score\", \"Freedom\", \"Trust..Government.Corruption.\" FROM \"2017\" WHERE \"Trust..Government.Corruption.\" IS NOT NULL ORDER BY \"Trust..Government.Corruption.\" DESC LIMIT 15",
"description": "Countries with highest government trust scores in 2017."
},
{
"query": "SELECT \"Country or region\", \"Score\", \"GDP per capita\", \"Social support\" FROM \"2018\" ORDER BY \"Score\" DESC LIMIT 10",
"description": "Top 10 happiest countries in 2018 with GDP and social support metrics."
},
{
"query": "SELECT \"Country or region\", \"Score\" FROM \"2019\" WHERE \"Freedom to make life choices\" IS NOT NULL ORDER BY \"Freedom to make life choices\" DESC LIMIT 10",
"description": "Countries with highest freedom to make life choices in 2019."
},
{
"query": "SELECT \"Region\", COUNT(*) AS country_count, AVG(\"Economy (GDP per Capita)\") AS avg_gdp FROM \"2015\" WHERE \"Economy (GDP per Capita)\" IS NOT NULL GROUP BY \"Region\" ORDER BY avg_gdp DESC",
"description": "Average GDP per capita by region in 2015 with country counts."
},
{
"query": "SELECT \"Country\", \"Happiness Score\", \"Family\", \"Health (Life Expectancy)\" FROM \"2016\" WHERE \"Region\" = 'Sub-Saharan Africa' ORDER BY \"Happiness Score\" DESC LIMIT 10",
"description": "Top 10 Sub-Saharan African countries by happiness in 2016."
},
{
"query": "SELECT \"Country or region\", \"Generosity\", \"Score\" FROM \"2019\" WHERE \"Generosity\" IS NOT NULL ORDER BY \"Generosity\" DESC LIMIT 10",
"description": "Most generous countries in 2019 by generosity score."
},
{
"query": "SELECT \"Country\", \"Happiness Score\", \"Freedom\" FROM \"2015\" WHERE \"Region\" = 'Middle East and Northern Africa' ORDER BY \"Freedom\" DESC LIMIT 10",
"description": "Middle Eastern countries ranked by freedom score in 2015."
}
]
}
```