B-4A, Adjusted Gross Income Class Comparison, All Filing Statuses

CREATE TABLE b_4a_adjusted_gross_income_class_comparison_all_filing_statuses (
  "taxable_year" BIGINT,
  "agic_sortid" BIGINT,
  "agic" VARCHAR,
  "all_returns" BIGINT,
  "taxable_returns" BIGINT,
  "federal_agi" BIGINT,
  "california_adjustments" BIGINT,
  "california_agi" BIGINT,
  "california_deductions" BIGINT,
  "taxable_income" BIGINT,
  "total_tax_liability" BIGINT,
  "returns_with_wages_and_salaries" VARCHAR,
  "wages_and_salaries" BIGINT,
  "returns_with_taxable_interest" VARCHAR,
  "taxable_interest" BIGINT,
  "returns_with_taxable_dividends" VARCHAR,
  "taxable_dividends" BIGINT,
  "returns_with_taxable_pensions_and_annuities" BIGINT,
  "taxable_pensions_and_annuities" BIGINT,
  "returns_with_business_income_profit" VARCHAR,
  "business_income_profit" BIGINT,
  "returns_with_business_income_loss" VARCHAR,
  "business_income_loss" BIGINT,
  "returns_with_net_sale_of_capital_assets_profit" VARCHAR,
  "net_sale_of_capital_assets_profit" BIGINT,
  "returns_with_net_sale_of_capital_assets_loss" VARCHAR,
  "net_sale_of_capital_assets_loss" BIGINT,
  "returns_with_rents_and_royalties_profit" VARCHAR,
  "rents_and_royalties_profit" BIGINT,
  "returns_with_rents_and_royalties_loss" VARCHAR,
  "rents_and_royalties_loss" BIGINT,
  "returns_with_partnerships_and_s_corp_gain" VARCHAR,
  "partnerships_and_s_corp_gain" BIGINT,
  "returns_with_partnerships_and_s_corp_loss" VARCHAR,
  "partnerships_and_s_corp_loss" BIGINT,
  "returns_with_estates_and_trusts_gain" VARCHAR,
  "estates_and_trusts_gain" VARCHAR,
  "returns_with_estates_and_trusts_loss" VARCHAR,
  "estates_and_trusts_loss" VARCHAR,
  "returns_with_farm_income_profit" VARCHAR,
  "farm_income_profit" VARCHAR,
  "returns_with_farm_income_loss" VARCHAR,
  "farm_income_loss" VARCHAR,
  "returns_with_all_other_federal_income_sources_profit" BIGINT,
  "all_other_federal_income_sources_profit" BIGINT,
  "returns_with_all_other_federal_income_sources_loss" VARCHAR,
  "all_other_federal_income_sources_loss" BIGINT,
  "returns_with_total_income" VARCHAR,
  "total_income" VARCHAR,
  "returns_with_individual_retirement_plan" VARCHAR,
  "individual_retirement_plan" BIGINT,
  "returns_with_student_loan_interest" VARCHAR,
  "student_loan_interest" VARCHAR,
  "returns_with_tuition_and_fees" VARCHAR,
  "tuition_and_fees" VARCHAR,
  "returns_with_moving_expense" VARCHAR,
  "moving_expense" VARCHAR,
  "returns_with_half_self_employment_tax" VARCHAR,
  "half_self_employment_tax" BIGINT,
  "returns_with_self_employed_health_insurance" VARCHAR,
  "self_employed_health_insurance" BIGINT,
  "returns_with_self_employed_retirement_plan" VARCHAR,
  "self_employed_retirement_plan" VARCHAR,
  "returns_with_penalty_on_early_withdrawal_of_savings" VARCHAR,
  "penalty_on_early_withdrawal_of_savings" BIGINT,
  "returns_with_alimony_paid" VARCHAR,
  "alimony_paid" VARCHAR,
  "returns_with_domestic_production" VARCHAR,
  "domestic_production" VARCHAR,
  "returns_with_total_adjustments" VARCHAR,
  "total_adjustments" BIGINT,
  "returns_with_total_california_subtractions" BIGINT,
  "total_california_subtractions" BIGINT,
  "returns_with_total_california_additions" VARCHAR,
  "total_california_additions" BIGINT,
  "returns_with_medical_expenses" VARCHAR,
  "medical_expenses" VARCHAR,
  "returns_with_state_and_local_income_taxes" VARCHAR,
  "state_and_local_income_taxes" BIGINT,
  "returns_with_real_estate_taxes" VARCHAR,
  "real_estate_taxes" BIGINT,
  "returns_with_personal_property_taxes" VARCHAR,
  "personal_property_taxes" VARCHAR,
  "returns_with_other_taxes" VARCHAR,
  "other_taxes" BIGINT,
  "returns_with_total_taxes" VARCHAR,
  "total_taxes" BIGINT,
  "returns_with_mortgage_interest" VARCHAR,
  "mortgage_interest" BIGINT,
  "returns_with_points_and_investment_interest" VARCHAR,
  "points_and_investment_interest" BIGINT,
  "returns_with_total_interest" VARCHAR,
  "total_interest" BIGINT,
  "returns_with_cash_or_check_contributions" VARCHAR,
  "cash_or_check_contributions" BIGINT,
  "returns_with_non_cash_contributions" VARCHAR,
  "non_cash_contributions" BIGINT,
  "returns_with_contribution_carryover" VARCHAR,
  "contribution_carryover" BIGINT,
  "returns_with_total_contributions" VARCHAR
);