-- BoltForce SOQL Editor • AI-Powered
SELECT Id, Name, Email,
Account.Name, Title,
CALENDAR_YEAR(CreatedDate)
FROM Contact
WHERE Account.Industry = 'Technology'
AND LastModifiedDate = LAST_N_DAYS:30
ORDER BY Name
LIMIT 200
-- 127 rows returned in 0.38s
-- Export: CSV JSON Clipboard
SELECT Id, StageName,
SUM(Amount) TotalAmount
FROM Opportunity
WHERE CloseDate = THIS_YEAR
GROUP BY StageName
-- StageName TotalAmount
-- Prospecting $1,240,000
-- Closed Won $3,820,000
-- Closed Lost $540,000
SELECT Id, Name, Email,
Account.Name, Title,
CALENDAR_YEAR(CreatedDate)
FROM Contact
WHERE Account.Industry = 'Technology'
AND LastModifiedDate = LAST_N_DAYS:30
ORDER BY Name
LIMIT 200