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
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.