PHPMem v2.0.1
Version
1.6.45
Uptime
16 days 22 hours 44 minutes 2 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
193 104
Rejected
0
llm:091e6be626b3e798e3ec1c4c9bcb28c979fc163d1dfc0528a0b0c16e24dc5bab
Edit
{
"action": "tool_call",
"reasoning": "Time dimension = monthly tables Jan-May 2022. Compute per-month round counts and total/median disclosed amount. Amount is VARCHAR, so strip '$' and ',' and use TRY_CAST.",
"tool": "query_sql",
"args": {
"sql": "WITH u AS (SELECT 1 AS m, 'Jan' AS month, \"Company Name\" AS c, Amount AS a FROM raw.\"Indian Startups _ Funding Investors Data January 2022\" UNION ALL SELECT 2, 'Feb', \"Company Name\", Amount FROM raw.\"Indian Startups _ Funding Investors Data February 2022\" UNION ALL SELECT 3, 'Mar', \"Company Name\", Amount FROM raw.\"Indian Startups _ Funding Investors Data March 2022\" UNION ALL SELECT 4, 'Apr', \"Company Name\", Amount FROM raw.\"Indian Startups _ Funding Investors Data April 2022\" UNION ALL SELECT 5, 'May', \"Company Name\", Amount FROM raw.\"Indian Startups _ Funding Investors Data May 2022\"), p AS (SELECT m, month, c, a, TRY_CAST(REPLACE(REPLACE(a, '$', ''), ',', '') AS DOUBLE) AS amt FROM u) SELECT month, COUNT(c) AS rounds, COUNT(amt) AS rounds_with_amount, SUM(amt) AS total_usd, MEDIAN(amt) AS median_usd, COUNT(*) - COUNT(c) AS blank_rows FROM p GROUP BY m, month ORDER BY m",
"purpose": "Monthly trend of funding rounds and disclosed amounts Jan-May 2022",
"source": "raw"
}
}