PHPMem v2.0.1

Version
1.6.45
Uptime
17 days 1 hour 34 minutes 12 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
15 / 1 024 max
Total
194 650
Rejected
0
llm:6225741305438e1f8b1ad9dced4c6917ed9ebf8bddd264aeb27ef42a86fb157a
TTL 6 days 1 hour 39 minutes 9 seconds Size 935,00B Export
Edit
<invoke name="query_sql"> <parameter name="sql">WITH p AS (SELECT regexp_extract("Date dd/mm/yyyy", '(\d{1,2})/(\d{1,2})/(\d{4})', 3) AS yr, regexp_extract("Date dd/mm/yyyy", '(\d{1,2})/(\d{1,2})/(\d{4})', 2) AS mo, TRY_CAST(REPLACE(REPLACE("Amount in USD", ',', ''), ' ', '') AS DOUBLE) AS amt FROM raw.startup_funding) SELECT yr, CASE WHEN mo = '' THEN NULL ELSE (CAST(mo AS INTEGER) - 1) / 3 + 1 END AS qtr, COUNT(*) AS deals, COUNT(amt) AS deals_with_amount, SUM(amt) AS total_usd, MEDIAN(amt) AS median_usd, MAX(amt) AS max_usd FROM p GROUP BY 1, 2 ORDER BY 1, 2</parameter> <parameter name="purpose">Quarterly deal counts and funding amounts to spot spikes, dips and gaps</parameter> <parameter name="source">raw</parameter> </invoke> </tool_call> </parameter> </invoke> Wait, I must output only JSON.