PHPMem v2.0.1
Version
1.6.45
Uptime
16 days 19 hours 35 minutes 6 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
191 755
Rejected
0
llm:c9d2f0d96473de87009fd791c47f940691984fc15cb910af7ee53dba1252914f
Edit
<invoke name="query_sql">
<parameter name="sql">WITH u AS (
SELECT 'Jan' AS month, 1 AS m, "Company Name" AS company, Amount, Stage FROM raw."Indian Startups _ Funding Investors Data January 2022"
UNION ALL SELECT 'Feb', 2, "Company Name", Amount, Stage FROM raw."Indian Startups _ Funding Investors Data February 2022"
UNION ALL SELECT 'Mar', 3, "Company Name", Amount, Stage FROM raw."Indian Startups _ Funding Investors Data March 2022"
UNION ALL SELECT 'Apr', 4, "Company Name", Amount, Stage FROM raw."Indian Startups _ Funding Investors Data April 2022"
UNION ALL SELECT 'May', 5, "Company Name", Amount, Stage FROM raw."Indian Startups _ Funding Investors Data May 2022"
), rep AS (SELECT company FROM u WHERE company IS NOT NULL GROUP BY company HAVING COUNT(DISTINCT m) > 1)
SELECT u.company, u.month, u.Amount, u.Stage FROM u JOIN rep USING (company) ORDER BY u.company, u.m</parameter>
<parameter name="purpose">Verify which companies repeat across months and compare their amounts and stages</parameter>
<parameter name="source">raw</parameter>
</invoke>