PHPMem v2.0.1
Version
1.6.45
Uptime
17 days 19 hours 3 minutes 43 seconds
Memory
Total
512MB
Used
12,72MB (2.48%)
Free
499,28MB
Keys
Current
14 060
Total (since start)
40 994
Evictions
0
Reclaimed
760
Expired Unfetched
0
Evicted Unfetched
0
Connections
Current
3 / 1 024 max
Total
240 958
Rejected
0
llm:bc0093533e6563724635fa559112bc7856b5c7dea781165de2bc6944fcf81f18
Edit
<invoke name="query_sql">
<parameter name="sql">WITH t AS (
SELECT 'Industry Vertical' AS col, "Industry Vertical" AS v FROM raw.startup_funding
UNION ALL SELECT 'SubVertical', "SubVertical" FROM raw.startup_funding
UNION ALL SELECT 'City Location', "City Location" FROM raw.startup_funding
UNION ALL SELECT 'InvestmentnType', "InvestmentnType" FROM raw.startup_funding
), c AS (
SELECT col, v, COUNT(*) AS n FROM t GROUP BY col, v
), r AS (
SELECT col, v, n, ROUND(100.0 * n / SUM(n) OVER (PARTITION BY col), 1) AS pct, ROW_NUMBER() OVER (PARTITION BY col ORDER BY n DESC) AS rk FROM c
)
SELECT col, rk, v, n, pct FROM r WHERE rk <= 7 ORDER BY col, rk</parameter>
<parameter name="purpose">Top values and frequencies for main categorical columns</parameter>
</invoke>