2000 select AccountID, Id, Name, Amount, CloseDate, FiscalYear, FiscalQuarter, Fiscal, OwnerId, Owner.Name, Account.Region__c, Account.BillingCountry, StageName from Opportunity where isClosed = false AND Account.Region__c != null sf!23 sf jdbc:mysql://localhost:3306/sf?autoReconnect=true com.mysql.jdbc.Driver INSERT INTO opphistory (id, OppName, Amount, CloseDate, FiscalQuarter, FiscalYear, FiscalPeriod, OwnerId, OwnerName, Region, Country, Stage, ThisMonth, ThisQuarter, ThisYear, NextMonth, NextQuarter, NextYear, RecordDate, AccountId) VALUES (?, ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) 2000 SELECT Region__c, count(Id) FROM Lead WHERE Status NOT IN ('Dead', 'Disqualified', 'Dormant') AND CreatedDate = THIS_QUARTER Group by Region__c sf!23 sf jdbc:mysql://localhost:3306/sf?autoReconnect=true com.mysql.jdbc.Driver INSERT INTO quarterlyleads (Region, count, RecordDate) VALUES (?, ?, ?) 2000 SELECT Region__c, count(Id) FROM Lead WHERE Status NOT IN ('Dead', 'Disqualified', 'Dormant') AND CreatedDate = THIS_MONTH Group by Region__c sf!23 sf jdbc:mysql://localhost:3306/sf?autoReconnect=true com.mysql.jdbc.Driver INSERT INTO monthlyleads (Region, count, RecordDate) VALUES (?, ?, ?) 2000 SELECT AccountId, Amount, StageName, Owner.Name, CloseDate, Opp_End_Date__c FROM Opportunity WHERE IsWon = true AND CloseDate != null AND Opp_End_Date__c != null ORDER BY CloseDate ASC sf!23 sf jdbc:mysql://localhost:3306/sf?autoReconnect=true com.mysql.jdbc.Driver INSERT INTO wonopps (AccountID, Amount, StageName, OwnerName, CloseDate, OppEndDate, RecordDate) VALUES (?, ?, ?, ?, ?, ?, ?) 2000 SELECT Region__c, count(Id) FROM Account WHERE Deactivation_Date__c >= TODAY Group by Region__c sf!23 sf jdbc:mysql://localhost:3306/sf?autoReconnect=true com.mysql.jdbc.Driver INSERT INTO customers (Region, count, RecordDate) VALUES (?, ?, ?)