CREATE TABLE SPIncomeStatement(symbol VARCHAR(10) NOT NULL, periodEnding DATE NOT NULL,totalRevenue BIGINT NULL,
costofRevenue BIGINT NULL,grossProfit BIGINT NULL,researchDevelopment BIGINT NULL,sellingGeneralandAdministrative BIGINT NULL,
nonRecurring BIGINT NULL,others BIGINT NULL,totalOperatingExpenses BIGINT NULL,operatingIncomeorLoss BIGINT NULL,
totalOtherIncome BIGINT NULL,earningsBeforeInterestAndTaxes BIGINT NULL,interestExpense BIGINT NULL,
incomeBeforeTax BIGINT NULL,incomeTaxExpense BIGINT NULL,minorityInterest BIGINT NULL,netIncomeFromContinuingOps BIGINT NULL,
discontinuedOperations BIGINT NULL,extraordinaryItems BIGINT NULL,effectOfAccountingChanges BIGINT NULL,
otherItems BIGINT NULL,netIncome BIGINT NULL,preferredStockAndOtherAdjustments BIGINT NULL,
netIncomeApplicableToCommonShares BIGINT NULL, PRIMARY KEY(symbol,periodEnding));