PHPMem v2.0.1
Version
1.6.45
Uptime
16 days 22 hours 43 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
15 / 1 024 max
Total
193 091
Rejected
0
llm:97d7e6ee6d3e8b5a9df78a7eedda3d25250e77f07973a41104742672c0e5b7c4
Edit
<invoke name="query_sql">
<parameter name="sql">WITH u AS (
SELECT 'Jan' AS month, "Company Name" AS company, Stage, Amount AS raw_amount FROM raw."Indian Startups _ Funding Investors Data January 2022"
UNION ALL SELECT 'Feb', "Company Name", Stage, Amount FROM raw."Indian Startups _ Funding Investors Data February 2022"
UNION ALL SELECT 'Mar', "Company Name", Stage, Amount FROM raw."Indian Startups _ Funding Investors Data March 2022"
UNION ALL SELECT 'Apr', "Company Name", Stage, Amount FROM raw."Indian Startups _ Funding Investors Data April 2022"
UNION ALL SELECT 'May', "Company Name", Stage, Amount FROM raw."Indian Startups _ Funding Investors Data May 2022"
), p AS (
SELECT month, company, Stage, raw_amount, TRY_CAST(REPLACE(REPLACE(raw_amount, '$', ''), ',', '') AS DOUBLE) AS usd FROM u
)
SELECT * FROM (SELECT 'highest' AS kind, * FROM p WHERE usd IS NOT NULL ORDER BY usd DESC LIMIT 5)
UNION ALL
SELECT * FROM (SELECT 'lowest' AS kind, * FROM p WHERE usd IS NOT NULL ORDER BY usd ASC LIMIT 5)</parameter>
<parameter name="purpose">Rank highest and lowest parsed funding Amount across all five monthly tables</parameter>
<parameter name="source">raw</parameter>
</invoke>
</tool_call>
Wait — that must be JSON only.
<invoke name="query_sql">
</invoke>
</tool_call>