PHPMem v2.0.1
Version
1.6.45
Uptime
16 days 22 hours 44 minutes 27 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 110
Rejected
0
llm:6ab0d65549e1ffd6a4abb9de7cce7a63e025520de1696f5fa68474c14011f7ae
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>